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 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 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 OrderDateand 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 theOrderDetails 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 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 andOrderDetails
  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

Refer to the exhibit.

A global sales organization operates in three regions: AMERICAS, EMEA: and APAC. Each region stores its sales transactions in a separate database in which the employees update customer data through a third-party app. The data is extracted into three QVDs.
A data architect sets up a two-tier architecture for the data load. The data architect needs to add the region to the data model.
Which technique should the data architect use to create the Region field?

• A. Create a Region field in the SalesTransaction table and create a mapping table based on the Country field in the Customer table
• B. Create a Region field in the Employee table and populate using the LTrim function on the EmployeelD
• C. Create a Region field in the SalesTransaction table and populate using fixed region values while loading from each source
• D. Create a Region field in the Employee table and populate using the SubField function on the EmployeelD

Refer to the exhibit.

A data architect is loading the tables and a synthetic key is generated.
How should the data architect resolve the synthetic key?

• A. Remove the LineNo field from both tables and use the AutoNumber function on the OrderlD field
• B. Remove the LineNo field from Shipments and use the AutoNumber function on the OrderlD field
• C. Create a composite key using OrderlD and LineNo
• D. Create a composite key using OrderlD and LineNo, and remove OrderlD and LineNo from Shipments

Refer to the exhibits.

Some business users created an app by using the Add data functionality and loading two Excel files Orders and Customers.
The app is used to analyze the number of orders by customer. When the users create a bar chart to review the figures, the data shown is incorrect.
What should the data architect do to resolve this issue?

• A. Open the data manager, split the Customers table, and associate both tables on CustomerlD field
• B. Open the data load editor and apply a NOCONCATENATE function in the LOAD statement on the Orders table
• C. Open the data manager, split the Customers table, and JOIN Orders and Customers on the CustomerlD field
• D. Open the data load editor and use JOIN instead of concatenate to combine Orders and Customers by CustomerlD