Qlik Exam QSDA2022 Topic 2 Question 12 Discussion

Actual exam question for Qlik's QSDA2022 exam

Question #: 12
Topic #: 2

[All QSDA2022 Questions]

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?

ACreate a composite key using OrderlD and LineNo

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

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

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

Show Suggested Answer

Suggested Answer: A

This is the recommended approach to resolving synthetic keys, as it allows you to maintain the integrity of the data by combining two or more fields into a single key. The composite key can then be used to join the two tables together, ensuring that the data is consistent and accurate.

by Emerson at Oct 07, 2023, 08:54 PM

Limited Time Offer

25%

Off

Get Premium QSDA2022 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!