Qlik QSDA2019 問題集

質問 1：
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 dat a. 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
正解：C

質問 2：
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 C
C. Option D
D. Option B
正解：B

質問 3：
A data architect needs to create an app that combines employee data from the Sales system and the Human Resources (HR) system.
These systems identify employees differently. Employees in the HR system are identified with an alpha-numeric key. Employees in the Sales system are identified using an integer key The Human Resources manager creates a table which maps these keys to one another, called Associations.
The resultant data model must meet the following requirements:
* Associations must be valid
* The model must be optimized for performance
* The option must support multiple tables added from both systems now and in the future Which function should the data architect use to meet these requirements?
A. APPLYMAP { 'Associations' , EmployeeKey) AS EmployeeKey;
B. MAP EmployeeKey USING Associations;
C. MapSubString('Associations', EmployeeKey) AS EmployeeKey;
D. RENAME FIELDS USING Associations;
正解：A

質問 4：
A data architect needs to create an app to analyze 30-day re-admissions at a hospital.
* The medical record system does NOT calculate re-admission data
* The business rule to follow: if a patient is admitted to a hospital within 30 days after being discharged from a previous hospital stay, that event should be captured in the app with a flag called "30-day Re-admission"
* Data being used from the patient record includes hospital account ID, patient ID, admission dater and discharge dateWhich action should the data architect perform first to meet these requirements?
A. Calculate the days since previous discharge using admission date and discharge date
B. Sequence patient records by patient ID using the Peek function
C. Order patient records by patient ID and admission date
D. Sequence patient records by hospital account ID and patient ID using the Peek function
正解：D

質問 5：
Refer to the exhibit.

A data architect has a data model that includes historical order fulfillment centers. The order fulfillment centers occasionally changed location. The history of order fulfillment must be tracked on a per center, per location basis.
Which scripting function should the data architect use to meet this data modeling requirement?
A. Inner Join
B. Peek
C. IntervalMatch
D. ApplyMap
正解：C