Qlik Sense Data Architect Certification - June 2019 Release: QSDA2019

A data architect needs to write the expression for a measure on a KPI to show the sales person with the

highest sales. The sort order of the values of the fields is unknown. When two or more sales people have

sold the same amount, the expression should return all of those sales people.

Which expression should the data architect use?

A. Concat(DISTINCT IF{Aggr{Rank{Sum(Sales),4),Salesperson)=1,Salesperson),' ')

B. FirstSortedValue{DISTINCT Salesperson,-Aggr{Sum(Sales),Salesperson))

C. Concat(DISTINCT IF{Aggr{Rank{Sum(Sales),1),Salesperson)=1, Salesperson) , ' ')

D. FirstSortedValue {Salesperson, -Aggr (Sum{Sales), Salesperson))

A data architect wants to combine data on present and historic sales performance. The historic data is

stored in a de-normalized archive, and the present data is maintained in a database. The output must be

contained in a single table.

Which script should the data architect use?

A. Option A

B. Option B

C. Option C

D. Option D

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)

A. Option A

B. Option B

C. Option C

D. Option D