Free Qlik QSDA2018 Exam Dumps Questions & Answers

A customer must create a production app that pulls data from two sources Source 1 is a large legacy system It takes more than one hour to read and save the data to a QVD Reading from the QVD only takes 20 seconds The data only needs to be refreshed every month because it does not change very often Source 2 is a small online data source Reloading this data takes less than one minute The production app must be refreshed every hour to see the most updated data and needs both data sets to meet the analysis requirements How should the data architect set up the data reload?

• A.1 Create two QVD generation apps
  2- Create two scheduled tasks one runs every month and one runs every hour
  3. Load the data in the production app from the QVDs
  4. Create a task to run every hour to reload the production app
• B.1. Create a QVD generation app to pull both data sources in different script sections
  2. Create two reload schedules from the QVD app based on the script section
  3. Build the production app using the QVD files
  4. Create a task to run every hour to reload the production app
• C.1 Create the productioff app to connect to both data sources
  2. Create a variable and set this to the last reload time using ReloadTimeQ function
  3. Use an IF() statement and only load the legacy data when TodayO > 30 days from last reload 4 Create a task to run every hour to reload the production app
• D.1. Create a QVD generation app for the legacy system only
  2. Create a scheduled task to generate the QVD every month
  3 Build the production app using the QVD and use ADD LOAD prefix to connect to the online data source
  4. Create a task to run every hour to perform a partial reload on the production app

Refer to the exhibit.

A fashion retail company needs to analyze data about product inventory. The company needs to filter by attributes by such as color, material, and size.
Which strategy should a data architect use to meet these requirements?

• A.Loop through the table to transpose fields
• B.Use crosstable in the load statement to unpivot
• C.Use the hierarchy load statement to expand hierarchy levels
• D.Turn data rows into fields by using a generic load

Refer to the exhibit.

A global company recently released an app that uses much more memory than similar apps have used When reviewing data in the data manager, the data architect observes that several fields use Globally Unique Identifiers (GUIDs). There is one key field. Other fields are used for different KPIs to count the number records. The data architect must reduce the memory used as much as possible. Which steps should a data architect take to meet these requirements?

• A.1 Replace the non-key field GUIDs with RowNoQ to maintain a field that can be used to get a unique count 2. Split the linking GUID fields into five sections using the SubField function to reduce the uniqueness
• B.1. Use the IterNoQ function to convert the linking GUIDs to numbers
  2 Replace the non-linking GUID fields with RowNo() to create an Index field and use to get a unique count for KPI
• C.1 Use the AutoNumber function to convert the linking GUIDs to numbers
  2. Use Indexing for non-key GUID fields to create an Index field and use to get a unique count for KPIs
• D.1 Use the AutoNumber function to convert the linking GUIDs to numbers
  2 Replace the non-key GUID fields with a flag, and use them to get a unique count for KPIs

Refer to the exhibit.
A data architect is reviewing an app that is under development. The app has NOT been published All data has been validated in all charts and KPIs. The data architect notices that the data model has two fact tables with common field names that cause a synthetic join Which step should the data architect take to correct the data model without affecting the app?

• A.Perform a mapping load for the Employees table and use ApplyMap in the Sales and Budget tables
• B.Create a composite key in the Sales and Budget tables that consists of the Year, EmployeelDr and ProductID
• C.Concatenate LOAD the data from the Sales and Budget tables to combine into a single table
• D.Create a composite key in the Sales and Budget tables instead of loading Year Employee!^ and ProductID

Refer to the exhibit

The business analyst previews some data and notices different values for the United States in the Country field. The analyst must be able to report the total sales for the United States The data architect must fix this issue in the LOAD script.
Which function should the data architect use to fix this data quality issue?

• A.Switch
• B.ApplyMap
• C.Replace
• D.Case