QlikView QSDA2018 Exam Questions & Answers

Refer to the exhibits.

A company notices that product sales have decreased. A data architect needs to create an app to show the correlation between the decreased revenue and the latest customer survey results.

Which Qlik Sense feature should the data architect use to meet this requirement?

A. Section access

B. On-demand App Generation

C. Master item library

D. Associative data model

Refer to the exhibits.

A data architect must load the two tables without creating a synthetic key. The data architect also must make sure expressions like Sum ([Budgeted Sales]) are calculated correctly.

Which load script meets these requirements?

A.

B. C.

D.

A customer must create a production app that pulls data from two sources.

Source 1 is large legacy system. It takes more than one hour to read and save the data to 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 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 te 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 production app to connect to both data sources

2.

Create a variable and set this to the last reload time using ReloadTime() function

3.

Use an IF() statement and only load the legacy data when Today() > 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