Refer to the exhibit.

A data architect is creating an app using three tables. After executing the script, a warning displays Which two steps should the data architect do to resolve this warning? (Select two.)

• A. Remove the rename statement (line 24) in the ProductPriceList table leaving the Product field name as is.
• B. insert "Join (ProductDetails)" in front of the Load statement in line 24 to combine ProductPriceList with ProductDetails
• C. Move the preceding Load statement in line 10 between table name (line 23) and Load statement (line 24).
• D. Rename the Category field in the ProductPriceLis table to PnceCategory (line 24).

A data architect needs to develop a script to export tables from a model based upon rules from an independent file. The structure of the text file with the export rules is as follows:

These rules govern which table in the model to export, what the target root filename should be, and the number of copies to export.
The TableToExport values are already verified to exist in the model.
In addition, the format will always be QVD, and the copies will be incrementally numbered.
For example, the Customer table would be exported as:
What is the minimum set of scripting strategies the data architect must use?

• A. One loop and one SELECT CASE statement
• B. One loop and two IF statements
• C. Two loops without any conditional statement
• D. Two loops and one IF statement

Refer to the exhibits.

A business analyst needs to see the currency conversion provided by a third party process, and only contains a record when the rate changes in a chart. The currency conversion rate data is An existing master calendar exists in the data model that contains a full set of dates.
Which technique should the data architect use to meet this requirement?

• A. OUTER JOIN the calendar with the currency conversion table
  ORDER BY the date and use the PEEK function to fill in blank values
• B. Utilize INTERVALMATCH to load the currency conversion rate between dates the conversation changed INNER JOIN the resultant table back into the master calendar
• C. Leverage a FOR loop between the start date and end date of the master calendar Use the MATCH function to add the currency conversion rates to the master calendar
• D. Use ITERNO and AUTOGENERATE to create a new calendar from max and min dates of the currency conversion table

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 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 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
• C. 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
• D. 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