1. Home
  2. Discussions
  3. Qlik
  4. Qlik Sense Data Architect
  5. QSDA2021 Discussions
  6. QSDA2021 Exam Topic 1 Question 2 Discussion

Qlik Sense Data Architect Certification Exam - February 2021 Release QSDA2021 Question # 2 Topic 1 Discussion

 Qlik Discussions      Browse All Questions      Go to Exam Detail      Get Premium Access
 Previous
Next  

Qlik Sense Data Architect Certification Exam - February 2021 Release QSDA2021 Question # 2 Topic 1 Discussion

QSDA2021 Exam Topic 1 Question 2 Discussion:
Question #: 2
Topic #: 1

Refer to the exhibit.

QSDA2021 Question 2

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 tliey 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. 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 OrderDeta Is table and in the Shipments table

2. Delete the ShipmentID in the Orders table

3. Delete the ProductID and OrderlD in the Shipmi

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 tab e and in the Orders table

2. Delete the ShipmentID in the Shipments table

3. Delete the ProductID and OrderlD in the OrderDetails

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 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

Get Premium QSDA2021 Questions
Actual exam question for Qlik QSDA2021 exam by Zara9447 at Aug 3, 2025, 12:00:00 AM

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.

Submit
 Previous
Next