Qlik Sense Data Architect Certification (QSDA2019) Free Practice Test
Question 1
Refer to the exhibit.
The data architect needs to create a KPI that displays the average amount of orders per customer. This aggregated field should be added to the existing orders table Which script should the data architect use?
A)
B)
C)
D)
The data architect needs to create a KPI that displays the average amount of orders per customer. This aggregated field should be added to the existing orders table Which script should the data architect use?
A)
B)
C)
D)
Correct Answer: B
Question 2
Refer to the exhibit.
The Section Access security table for an app is shown User ABC\PPP opens a Qlik Sense app with a table using the field called LEVEL on one of the table columns What is the result?
The Section Access security table for an app is shown User ABC\PPP opens a Qlik Sense app with a table using the field called LEVEL on one of the table columns What is the result?
Correct Answer: A
Question 3
Multiple department fields in a dataset require a description.
A data architect needs to add the department descriptions or a default value when the department does NOT have a description.
Which strategy should the data architect use to meet these requirements?
A data architect needs to add the department descriptions or a default value when the department does NOT have a description.
Which strategy should the data architect use to meet these requirements?
Correct Answer: A
Question 4
A data architect creates a collection of large QVD files that propagate data into their apps This solution works well.
However, a new app that uses a subset of the data in a QVD takes much longer than expected to reload The LOAD statement is
Which two changes should be made to improve load performance? (Select two ) A)
B)
C)
D)
However, a new app that uses a subset of the data in a QVD takes much longer than expected to reload The LOAD statement is
Which two changes should be made to improve load performance? (Select two ) A)
B)
C)
D)
Correct Answer: C
Question 5
A company needs to analyze sales data based on the exchange rate of the different countries every day About 30 reports must be produced with an average of 20r000 rows each. This process is estimated to take about three hours.
Reports will be in Excel and distributed to business users according to defined security rules Which two products should the data architect use to build this solution? (Select two.)
Reports will be in Excel and distributed to business users according to defined security rules Which two products should the data architect use to build this solution? (Select two.)
Correct Answer: B,C
Question 6
Users of a published app report incomplete visualizations. The data architect checks the app multiple times and cannot replicate the error. The error affects only one team What is the most likely cause?
Correct Answer: B