Refer to the exhibit.

A company stores the employee data within a key composed of Country, UserlD, and Department. These fields are separated by a blank space. The UserlD field is composed of two characters that indicate the country followed by a unique code of two or three digits. A data architect wants to retrieve only that unique code.
Which function should the data architect use?

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

解説: (CertJuken メンバーにのみ表示されます)

exhibit.

A data architect is validating that the script section, as shown in the exhibit, is working properly. They need to stop the script with a preview of the value used with the Load statement.
Where should the data architect put the debugger breakpoint?

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

解説: (CertJuken メンバーにのみ表示されます)

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. 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. 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. Left join Orders and OrderDetails
  5. Use Derive statement with the MasterCalendar table and apply the derive fields to OrderDate and ShipmentDate

解説: (CertJuken メンバーにのみ表示されます)

Refer to the exhibits.
On executing a load script of an app, the country field needs to be normalized. The developer uses a mapping table to address the issue. The script runs successfully but the resulting table is not correct.
What should the data architect do?

• A. Review the values of the source mapping table
• B. Create two different mapping tables
• C. Use a LEFT JOIN Instead of the APPLYMAP
• D. Use LOAD DISTINCT on the mapping table

解説: (CertJuken メンバーにのみ表示されます)

Exhibit.

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. Create a composite key using OrderlD and UneNo
• C. Create a composite key using OrderlD and LineNo, and remove OrderlD and LineNo from Shipments
• D. Remove the LineNo field from Shipments and use the AutoNumber function on the OrderlD field

解説: (CertJuken メンバーにのみ表示されます)