Refer to the exhibit.

Qlik QSDA2022 Question Answer

A data architect is loading the tables and a synthetic key is generated.

How should the data architect resolve the synthetic key?

Create a composite key using OrderlD and LineNo

Remove the LineNo field from Shipments and use the AutoNumber function on the OrderlD field

Remove the LineNo field from both tables and use the AutoNumber function on the OrderlD field

Create a composite key using OrderlD and LineNo, and remove OrderlD and LineNo from Shipments

QSDA2022 PDF/Engine

Get 75% Discount on All Products, Use Coupon: "ac75sure"