Free Qlik QSDA2024 Exam Dumps Questions & Answers

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 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
• 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. Concatenate Orders and OrderDetails
  5. Create a link table using the MasterCalendar table and create a concatenated field between 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. Concatenate Orders and OrderDetails
  5. Create a link table using the MasterCalendar table and create a concatenated field between OrderDate and ShipmentDate
• D.  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

A table is generated resulting from the following script:

When the data architect selects a date, some, but NOT all, orders for that date are shown.
How should the data architect modify the script to show all orders for the selected date?

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

A data architect executes the following script:

Which values does the OrderDate field contain after executing the script?

• A.  20210131, 2020/01/31, 31/01/2019, 31/12/2022
• B.  20210131, 2020/01/31, 31/01/2019, 9999
• C.  20210131, 2020/01/31, 31/01/2019, 0
• D.  20210131, 2020/01/31, 31/01/2019

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. 

Exhibit.

Refer to the exhibit.
A data architect is loading two tables into a data model from a SQL database. These tables are related on key fields CustomerlD and Customer Key.
Which script should the data architect use?

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