Qlik QSDA2019 問題集

質問 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)

A. Option A
B. Option C
C. Option D
D. Option B
正解：B

質問 2：
Refer to the exhibit.

This table contains information about the number of admissions and discharges of patients in a hospital. The values can be positive or negative. The data architect needs to create an extra column that contains the number of patients that are currently in the hospital.
Which script should the data architect use ?
A)

B)

C)

D)

A. Option A
B. Option C
C. Option D
D. Option B
正解：A

質問 3：
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

質問 4：
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

質問 5：
A data architect is using an Include statement to load the collection of variables from a TextFiles folder connection into an app. The data architect needs to load the data and generate an error if it fails.
Which statement should the data architect use?
A. $<Include=lib://TextFiles/Variables.txt);
B. $(Must_Include=lib://TextFiles/Variables.txt);
C. (Must_Include=lib://TextFiies/Variables.txt);
D. (Includs=lib://TextFiles/Variables.txt);
正解：A