Qlik QSDA2021 問題集

質問 1：
A data architect needs to develop a script to export tables from a model based upon rules from an independent file. The structure of the text file with the export rules is as follows:

These rules govern which table in the model to export, what the target root filename should be, and the number of copies to export.
The TableToExport values are already verified to exist in the model.
In addition, the format will always be QVD, and the copies will be incrementally numbered.
For example, the Customer table would be exported as:
What is the minimum set of scripting strategies the data architect must use?
A. Two loops without any conditional statement
B. One loop and two IF statements
C. One loop and one SELECT CASE statement
D. Two loops and one IF statement
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 2：
A data architect needs to upload data from ten different sources, but only if there are any changes after the last reload When data is updated, a new file is placed into a folder mapped to E A439926003 The data connection points to this folder.
The data architect plans a script which will:
1. Verify that the file exists
2. If the file exists, upload it Otherwise, skip to the next piece of code The script will repeat this subroutine for each source. When the script ends, all uploaded files will be removed with a batch procedure.
Which option should the data architect use to meet these requirements?
A. FilePath, FOR EACH, Peek, Drop
B. FileSize, IF, THEN, END IF
C. FileExists, FOR EACH, IF
D. FilePath, IF, THEN. Drop
正解：B

質問 3：
A data architect needs to efficiently prepare a data model for a meeting in an hour.
The data source to be used contains five date fields The app needs to display sales trends and compare the current year to date (CYTD) to last year to date (LYTD) The app is NOT going to be published It will only be used for this meeting and a single user's ad-hoc analysis.
What should the data architect do to meet these requirements?
A. Create five master calendars
B. Load a calendar island
C. Create a canonical calendar
D. Use the data manager
正解：C

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

B)

C)

D)

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

質問 5：
A data architect needs to add the UnitCost field from the ProductCost table in the Dim_Products Table.
Which script code should the data architect use?
A.

B.

C.

D.

正解：B