Qlik QSDA2022 問題集

質問 1：

A Human Resources Director needs an app to analyze organizational structure. The Directory is particularly interested in the longest levels of line management.
Two table loads are required. Both use the same basic structure.

Which two table load prefixes are needed?
A. * Hierarchy(EmployeelD. ManagerlD Name, Manager Name, Structure V,Depth)
* HierarchyLevelEmployeelD, ManagerlD, Name, Manager, Name, Structure, Depth '/')
B. * HierarchyBelongs.To(EmployeeID, ManagerlD, Name ManagerlD, Manager, Depth)
C. * HierarchyBelongsTo(ManagerlD, Manager, ManagerlD, ManagerlD, Manager Level)
* Hierarchy(EmployeelD, ManagerlD, Name. Manager Name, Structure '/' Depth)
D. *HierarchyLevel(EmployeelD, ManagerlD Name Level, '/', Structure)
*HierarchyBelongsTo(EmployeelD, ManagerlD, Name ManagerlD,Manager, Depth)
正解：B

質問 2：

Refer to the exhibit
A data architect is working on an app that contains orders, invoices, and shipping data. There are three different date fields within the data:
* OrderDate
* InvoiceDate
* ShippingDate
The business analyst needs to replicate the chart above to show Order and Shipping amounts on the same Month axis.
What should the data architect do?
A. Create a Month field for each of the three dates in the fact table and use that in the chart
B. Left Join the three date fields onto one bridge table using the key field containing KeyField and Date
C. Load the key field and the three date fields into a concatenated bridge table that contains KeyField and Date
正解：C

質問 3：
Refer to the exhibit.

USER1 has an app protected using this Section Access statement.
Which countries can USER1 see in the app''
A. Germany Italy, The Netherlands
B. Italy, The Netherlands
C. Germany. Italy, United Kingdom, The Netherlands
D. Italy, United Kingdom, The Netherlands
正解：D

質問 4：
Refer to the exhibits.

A music teacher needs to know which artists are eligible to enter this year's competition.
The teacher needs to find only the artists who have a music grade rank above two and play more than one instrument.
Which expression is needed for the Number of Instruments measure in the table?
A. Count ({S<Artist={"=Count(Instrument)>=2M}, Grades={">2"}>}Instrument)
B. Count({S<Count(Instrument)={">=2"}, Grades={">2"}>}Instrument)
C. Count({$<Artist={"=Count(Instrument)>=2"}, Artist={"=Grade>2"}>}Instrument)
D. Count({$<Instrument={">=2"}, Artist={"=Grade>2"}>}Instrument)
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 5：
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 Mapping Load
B. ApplyMap with three parameters after the Mapping load
C. ApplyMap with two parameters after the Mapping load
D. Left Join between tables and Description xlsx in every Department table
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 6：
A data architect builds a data model for a large user group. Some sheets will be published, and the app will allow users to create their own visualizations and analyze data. Some fields must NOT appear in any field list.
How should a data architect meet these requirements?
A. Use security rules
B. Add fields to master items
C. Use HidePrefix variable
D. Use HideField variable
正解：A
解説: (Topexam メンバーにのみ表示されます)