Online Access Free QSDA2019 Practice Test

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 aggregated data for two years and use ODAG for transaction data
• C.Load only aggregated data for two years and use Direct Discovery for transaction data
• D.Load only two years of data and use best practices in scripting and visualization to calculate and display aggregated data

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.Owner Publish, Read
• C.Publish
• 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 table is removed from the user interface
• B.The user gets an "Invalid visualization" error
• C.The table is displayed without the LEVEL column
• D.The user gets a "Field not found" error

Refer to the exhibit.

A shipping company needs to track its shipments using Qlik Sense A data architect has the data in Excel as shown on the left Business rules state that if the ShipmentDate field is empty, it should be populated with the first valid previous date as shown on the right. Which script should the data architect use to meet this requirement?
A)

B)

C)

D)

• A.Option C
• B.Option B
• C.Option A
• D.Option D

Refer to the exhibit.

A clothing retailer wants to review their product pricing strategy.
A data architect must classify each product into a price group. The price groups must be the same width by default and allow users to dynamically change the width of the bucket during analysis.
Which feature should the data architect use to meet these requirements?

• A.Class function in a calculated dimension
• B.Nested IFs in a calculated dimension
• C.Class function in the script and use variables
• D.IntervalMatch and use variables