Qlik QSDA2022 問題集

質問 1：

Refer io the exhibit.
A data architect needs to modify the script to ONLY load rows from Table_B when Field_1 and Field_2 are the same as in Table_A. (For example, only the row containing A, 1, 456 should be loaded from Table_B.) Which script should the data architect use?
A)

B)

C)

D)

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

質問 2：
Refer to the exhibit.

A customer needs to load forecast data from an Excel file.
Which preceding load statement should the data architect use to load the data?
A.

B.

C.

D.

正解：D

質問 3：
Refer to the exhibit.

A data architect is working with an app and creates some visualizations to check the data. Some visualizations showissues in the data set.
* The Sales by Country table shows a total OrderValue of 18,300 sales while the KPI shows a total OrderValue of 20,600.
* The Sales monthly trend bar chart does not work with the Month field.
Which two data issues should the data architect fix in the app? (Select two.)
A. The Month field does not exist in the Orders table and needs to be incorporated in the table using he Calendar table.
B. The OrderDate field values in the Calendar table do not match with the values in the OrderDate field from the Orders table
C. In the Orders table, some values in the CustomerlD field do not exist in the Customers table.
D. In the Orders table, some CustomerlD values are null because there are orders with no customer.
and needs to be incorporated in the table using the Calendar table, null because there are orders with no customer
正解：B,C

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

正解：A

質問 5：
A company decides to migrate all apps from QlikView to Qlik Sense. After converting an apps: there are several unconverted objects What should the data architect do?
A. Save the unconverted objects as extensions and import them into Qlik Sense
B. Save the unconverted objects as master items
C. Remove the set analysis statements from the unconverted objects
D. Re-create the unconverted objects
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 6：
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);
正解：B
解説: (Topexam メンバーにのみ表示されます)