QlikView QSDA2019 Exam Questions & Answers

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

Refer to the exhibit.

A clothing retailer wants to review their product pricing strategy. A data architect must classify each product into a price group. The price groups must be the same width by default and allow users to dynamically change the width of the bucket during analysis.

Which feature should the data architect use to meet these requirements?

A. IntervalMatch and use variables

B. Nested IFs in a calculated dimension

C. Class function in a calculated dimension

D. Class function in the script and use variables

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