Qlik QSDA2019 問題集

質問 1：
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. Enter "Missing description" in the blank rows for Description.xlsx, then use Mapping Load
B. Left Join between tables and Description.xlsx in every Department table
C. ApplyMap with three parameters after the Mapping load
D. ApplyMap with two parameters after the Mapping load
正解：D

質問 2：
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. FirstSortedValue{DISTINCT Salesperson,-Aggr{Sum(Sales),Salesperson))
B. Concat(DISTINCT IF{Aggr{Rank{Sum(Sales),4),Salesperson)=1,Salesperson),' ')
C. FirstSortedValue {Salesperson, -Aggr (Sum{Sales), Salesperson))
D. Concat(DISTINCT IF{Aggr{Rank{Sum(Sales),1),Salesperson)=1, Salesperson) , ' ')
正解：B

質問 3：
Refer to the exhibit.

A global sales organization operates in three regions: AMERICAS, EMEA: and APAC. Each region stores its sales transactions in a separate database in which the employees update customer data through a third-party app. The data is extracted into three QVDs.
A data architect sets up a two-tier architecture for the data load. The data architect needs to add the region to the data model.
Which technique should the data architect use to create the Region field?
A. Create a Region field in the SalesTransaction table and create a mapping table based on the Country field in the Customer table
B. Create a Region field in the Employee table and populate using the LTrim function on the EmployeelD
C. Create a Region field in the Employee table and populate using the SubField function on the EmployeelD
D. Create a Region field in the SalesTransaction table and populate using fixed region values while loading from each source
正解：A

質問 4：
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. Class function in the script and use variables
B. IntervalMatch and use variables
C. Nested IFs in a calculated dimension
D. Class function in a calculated dimension
正解：D

質問 5：
Refer to the exhibit.

A data architect is loading the tables and a synthetic key is generated.
How should the data architect resolve the synthetic key?
A. Create a composite key using OrderlD and LineNo, and remove OrderlD and LineNo from Shipments
B. Remove the LineNo field from both tables and use the AutoNumber function on the OrderlD field
C. Create a composite key using OrderlD and LineNo
D. Remove the LineNo field from Shipments and use the AutoNumber function on the OrderlD field
正解：C