QlikView QSDA2019 Online Practice Questions and Exam Preparation

QlikView QSDA2019 Online Questions & Answers

• Question 51:

  Refer to the exhibit.

  

  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:

  

  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
  C. Update the Exams table and add 33.4% of the missing records

• Question 52:

  A table is generated resulting from the following script

  

  When the data architect selects a date, some, but NOT all, orders for that date are shown How should the data architect modify the script to show all orders for the selected date? A)

  

  B)

  

  C)

  

  D)

  

  A. Option A
  B. Option B
  C. Option C
  D. Option D
  C. Option C