Qlik QSDA2021 問題集

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

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

質問 3：
Refer to the exhibit.

A company has different departments. Executive and Sales should always be the first values in a Department filter pane. Which script must the data architect use to meet this requirement?
A)

B)

C)

D)

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

質問 4：
A data architect executes the following script.

Which values does the OrderDate field contain after executing the script?
A. 20210131, 2020/01/31, 31/01/2019, 0
B. 20210131, 2020/01/31, 31/01/2019, 31/12/20
C. 20210131, 2020/01/31, 31/01/2019, 9999
D. 20210131,2020/01/31,31/01/2019
正解：B

質問 5：
Refer to the exhibits.

Some business users created an app by using the Add data functionality and loading two Excel files Orders and Customers.
The app is used to analyze the number of orders by customer. When the users create a bar chart to review the figures, the data shown is incorrect.
What should the data architect do to resolve this issue?
A. Open the data manager, split the Customers table, and JOIN Orders and Customers on the CustomerlD field
B. Open the data load editor and apply a NOCONCATENATE function in the LOAD statement on the Orders table
C. Open the data manager, split the Customers table, and associate both tables on CustomerlD field
D. Open the data load editor and use JOIN instead of concatenate to combine Orders and Customers by CustomerlD
正解：D