Qlik Sense Data Architect Certification Exam–2022 QSDA2022 Question # 15 Topic 2 Discussion

Qlik Sense Data Architect Certification Exam–2022 QSDA2022 Question # 15 Topic 2 Discussion

QSDA2022 Exam Topic 2 Question 15 Discussion:
Question #: 15
Topic #: 2

Refer to the exhibit.

QSDA2022 Question 15

A data architect builds a simple data model to show the relationship between students and exams. The data is loaded. Every StudentID in the Exams table should be found in the Students table. Some students have NOT taken an exam.

The data architect selects the field "StudentID" from the Students table and sees the following:

QSDA2022 Question 15

A data architect needs to fix this anomaly.

What should the data architect do to ensure data integrity?


A.

Update the Students table and add 16.7% of the missing records


B.

Remove records from the Exams table where StudentID is null


C.

Update the Exams table and add 33.4% of the missing records


D.

In the LOAD script, add DISTINCT before the Students and Exams tables


Get Premium QSDA2022 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.