Qlik Sense Data Architect Certification Exam (QSDA2018) - QlikView Exam Questions

The data model from an existing Qlik Sense app needs to be reused in another Qlik Sense app.

Which load strategy should a data architect use to transfer this data in the most efficient way?

Refer to the exhibit.



One of the data sources a data architect must add for a newly developed app is an Excel spreadsheet The Region field only has values for the first record for the region. The data architect must perform a transformation so that each row contains the correct Region. Which function should the data architect implement to resolve this issue?

An enterprise data warehouse contains 700 million records. This enterprise data warehouse has a three-tiered architecture and uses QVDs The Qhk Sense server contains 24 GB RAM and contains two processors with eight cores The company needs to allow vendors to access a Qlik Sense app anonymously to review past business transactions and current year-to-date performance.

Which method should the data architect use to meet this requirement?

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 chart for monthly hospital admissions and discharges incorrectly displays the month and year values on the x-axis. The date format for the source data field "Common Date" is M/D/YYYY This format was used in a calculated field named "Month-Year" in the data manager when the data model was first built. Which expression should the data architect use to fix this issue?