Qlik QSDA2021 問題集

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

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

正解：A

質問 3：
Refer to the exhibits.

While debugging an app, a developer loads data from an application layer QVD file.
In the process of separating a concatenated key into two parts, some split results are missing data What should the data architect do?
1. Utilize a combination of LEFT(), MID(), and RIGHT() functions to capture the key components
2. In the SUBFIELD function, replace the '_' with a '|' or '_' character.
While debugging an app, a developer loads data from an application layer QVD file.
In the process of separating a concatenated key into two parts, some split results are missing data What should the data architect do?
A. Wrap an IF() function around the SUBFIELDQ functions to check and adapt to null values character
B. Utilize a combination of LEFT(), MID(), and RIGHTO functions to capture the key components
C. Instruct the developer of the QVD file to correct the generation of the ConcatKeyAlpha field
D. Instruct the developer of the QVD file to correct the generation of the ConcatKeyAlpha field
E. Wrap an IF() function around the SUBFIELD() functions to check and adapt to null values
F. In the SUBFIELD function, replace the '- with a '|' or '-' character
正解：A

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

What will Field_1 contain after this script is executed?
A. Abed, abed, ABCD, ABCDABCD
B. abcd
C. Abed, abed, ABCD
D. Abcd, abcd
正解：C

質問 5：
A company has a stream with multiple apps One of the apps is a multi-regional sales app.
A data architect must set up security for users to access the stream, enter the app, and view specific sheets and data.
Which features should the data architect use to meet these requirements?
A. Section access and sheet properties
B. QMC security rules and section access
C. Section access and set analysis
D. QMC security rules and custom properties
正解：B