QSDA2019 Online Practice Questions and Answers

A company generates 1 GB of ticketing data daily. The data is stored in multiple tables Business users need to see trends of tickets processed for the past two years. Users very rarely access the transaction-level data for a specific date. Only the past two years of data must be loaded which is 720 GB of data Which method should a data architect use to meet these requirements?

A. Load only two years of data in an aggregated app and create a separate transaction app for occasional use

B. Load only two years of data and use best practices in scripting and visualization to calculate and display aggregated data

C. Load only aggregated data for two years and use Direct Discovery for transaction data

D. Load only aggregated data for two years and use ODAG for transaction data

Refer to the exhibit.

An existing app on Qlik Sense Enterprise is duplicated and transferred to a data architect to add some additional data When trying to manually reload the original script, the data architect receives an error What should be done to make sure the script runs correctly?

A. Add the line lib connect to 'QVD(abc_qservice/orderData.qvd) '; before the LOAD for the Order Data table

B. Add the line lib connect to ' SQL (abc_qs9rvi.es) ` ;before the LOAD for the Order Detail table

C. Give the data architect the Read rights on the data connections in the QMC

D. Make the data architect the owner of the app in the QMC

Users of a published app report incomplete visualizations. The data architect checks the app multiple times

and cannot replicate the error. The error affects only one team.

What is the most likely cause?

A. An Omit field has been applied

B. A security rule has been applied to the sheet object

C. Section access restricts too many records

D. The affected users were NOT added to the Section Access table

Refer to the exhibit.

A company has different departments Executive and Sales should always be the first values in a

Department filter pane.

Which script must the data architect use to meet this requirement?

A)

B)

C)

D)

A. Option A

B. Option B

C. Option C

D. Option D

A data architect completes development of a new app with two data sources Both data sources will also be used by other apps in the future The sources have different data refresh frequencies: Source 1 Contains frequently updated data and must be refreshed hourly Source 2 Contains data that is transferred from a partner and must be refreshed weekly

Tasks must be created to load the data sources and make sure that the new app uses the most current data The data will be stored in two QVDs.

Which tasks should be created to meet these requirements?

A. 1. ScheduleTask 1 to run hourly and refresh data from Source 1

2.

ScheduleTask 2 to run weekly and refresh data from Source 2

3.

Schedule a task for the app that is dependent on completion ofTasks 1 or 2 that loads the two QVDs

B. 1. ScheduleTask 1 to run hourly and refresh data from Source 1

2.

ScheduleTask 2 that is dependent onTask 1 to refresh data from Source 2

3.

Schedule a task for the app that is dependent on completion ofTask 2 that loads the two QVDs

C. 1. ScheduleTask 1 to run hourly and refresh data from Source 1

2.

ScheduleTask 2 that is dependent onTask 1 to refresh data from Source 2

3.

Schedule a task for the app that is dependent on completion ofTasks 1 and 2 that loads the two QVDs

D. 1. ScheduleTask 1 to run hourly and refresh data from Source 1

2.

ScheduleTask 2 to run weekly and refresh data from Source 2

3.

Schedule a task for the app that is dependent on completion ofTask 2 that loads the two QVDs

Refer to the exhibits.

A business analyst needs to see the currency conversion rate for any given date in a chart The currency conversion rate data comes from Qlik DataMarket and only contains a record when the rate changes An existing master calendar exists in the data model which contains a full set of dates.

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

A. Outer Join the calendar with the currency conversion table Order by the date and use the Peek function to fill in blank values

B. Use a FOR loop between the start date and end date of the master calendar Use the Match function to add the currency conversion rates to the master calendar

C. Use IntervalMatch to load the currency conversion rate between dates the conversion changed Inner Join the resultant table back into the master calendar

D. Use IterNo and AutoGenerate to create a new calendar from max and mm dates of the currency conversion table Force concatenate with the master calendar

Refer to the exhibit.

The data architect needs to create a KPI that displays the average amount of orders per customer. This aggregated field should be added to the existing orders table.

Which script should the data architect use?

A. Option A

B. Option B

C. Option C

D. Option D

A data architect executes the following script:

What will be the result of Table_A?

A. Option A

B. Option B

C. Option C

D. Option D

A human resources (HR) team manager is due to go on leave. The manager needs to assign permissions to colleague to help the HR team publish apps.

Which action(s) should the manager assign to the colleague before going on leave?

A. Owner Publish

B. Publish

C. Owner Publish, Read

D. Publish, Read

Refer to the exhibit.

The Section Access security table for an app is shown User ABC\PPP opens a Qlik Sense app with a table using the field called LEVEL on one of the table columns.

What is the result?

A. The user gets an "Invalid visualization" error

B. The table is displayed without the LEVEL column

C. The table is removed from the user interface

D. The user gets a "Field not found" error