QSDA2024 by Qlik Actual Free Exam Questions And Answers

Question 1

A data architect wants reflect a value of the variable in the script log for tracking purposes. The variable is defined as:

Which statement should be used to track the variable's value?

A.

B.

C.

D.

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 2

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.
Which is the result?

A. The user gets a 'Field not found' error.

B. The user gets an 'Incomplete visualization' error.

C. The table is displayed without the LEVEL column.

D. The table is removed from the user interface.

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 3

Exhibit.

Refer to the exhibit.
A data architect is provided with five tables. One table has Sales Information. The other four tables provide attributes that the end user will group and filter by.
There is only one Sales Person in each Region and only one Region per Customer.
Which data model is the most optimal for use in this situation?

A.

B.

C.

D.

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 4

Exhibit.

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.

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 5

Exhibit.

Refer to the exhibit.
A data architect is working on a Qlik Sense app the business has created to analyze the company orders and shipments.
To understand the table structure, the business has given the following summary:
* Every order creates a unique orderlD and an order date in the Orders table
* An order can contain one or more order lines one for each product ID in the order details table
* Products In the order are shipped (shipment date) as soon as they are ready and can be shipped separately
* The dates need to be analyzed separately by Year, Month, and Quarter
The data architect realizes the data model has issues that must be fixed. Which steps should the data architect perform?

A. 1. Create a key with OrderlD and ProductID in the OrderDetails table and in the Shipments table
2. Delete the ShipmentID in the Orders table
3. Delete the ProductID and OrderlD In the Shipments table
4. Concatenate Orders and OrderDetails
5. Create a link table using the MasterCalendar table and create a concatenated field between OrderDate and ShipmentDate

B. 1. Create a key with OrderlD and ProductID in the OrderDetails table and in the Orders table
2. Delete the ShipmentID in the Shipments table
3. Delete the ProductID and OrderlD in the OrderDetails table
4. Left join Orders and OrderDetails
5. Use Derive statement with the MasterCalendar table and apply the derive fields to OrderDate and ShipmentDate

C. 1. Create a key with OrderlD and ProductID in the OrderDetails table and in the Shipments table
2. Delete the ShipmentID in the Orders table
3. Delete the ProductID and OrderlD in the Shipments table
4. Left join Orders and OrderDetails
5. Use Derive statement with the MasterCalendar table and apply the derive fields to OrderDate and ShipmentDate

D. 1. Create a key with OrderlD and ProductID In the OrderDetails table and in the Orders table
2. Delete the ShipmentID in the Shipments table
3. Delete the ProductID and OrderlD in the OrderDetails table
4. Concatenate Orders and OrderDetails
5. Create a link table using the MasterCalendar table and create a concatenated field between OrderDate and ShipmentDate

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 6

A company generates l GB of ticketing data daily. The data is stored in multiple tables. Business users need to see trends of tickets processed for the past 2 years. Users very rarely access the transaction-level data for a specific date. Only the past 2 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 2 years of data and use best practices in scripting and visualization to calculate and display aggregated data

B. Load only aggregated data for 2 years and apply filters on a sheet for transaction data

C. Load only aggregated data for 2 years and use On-Demand App Generation (ODAG) for transaction data

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

Discussion 0

Correct Answer: C Vote an answer

Qlik Sense Data Architect Certification Exam - 2024 - QSDA2024 Exam Practice Test

Contact Us

Useful Links

Latest Updated