How to Resolve Synthetic Key in Qlik Data Model

Qlik QSDA2022 Question Answer

Refer to the exhibit.

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

How should the data architect resolve the synthetic key?

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

Create a composite key using OrdertD and LineNo

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

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

Qlik QSDA2022 Summary

Price: $52.5 ~~$149.99~~