Qlik QSDA2021 問題集

質問 1：
Refer to the exhibit.

Refer to the exhibits.
An app is built to analyze salesperson performance by department. Departments are unique within the Departments table, but Salespeople often move between departments. A strict business rule states that a salesperson must be associated with ONLY one department at all times.
The data architect creates a summary of department performance and notices the values are incorrect. The total sales KPI shows the correct result.
How should the data architect modify the data model to correct this issue?
A. Join the Transactions and Salespeople tables to resolve the many-to-many relationship
B. Create a bridge table between the Departments and Salespeople tables to resolve the many-to-many relationship
C. Join the Departments and Salespeople tables to resolve the many-to-many relationship
D. Create a bridge table between the Transactions and Salespeople tables to resolve the many-to-many relationship
正解：B

質問 2：
Users of a published app report incomplete visualizations. The data architect checks the app multiple times and cannot replicate the error. The error affects only one team.
What is the most likely cause?
A. An Omit field has been applied
B. Section access restricts too many records
C. The affected users were NOT added to the Section table
D. A security rule has been applied to the sheet object
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 3：
A data architect needs to load Table_A from an Excel file and sort the data by Field_2.
Which script should the data architect use?
A)

B)

C)

D)

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

質問 4：
Refer to the exhibit.

Refer to the exhibit.
A data architect is loading two tables: Orders and Product. The Product table includes attributes and values for each ProductID such as Colour, Price, Category, and Description.
The business analyst can filter by the value of these attributes. For performance reasons, the Data Model will use two tables.
Which solution should the data architect apply in the Data Load Editor to build the ProductDetails table?
For performance reasons, the Data Model will use two tables a Load Editor to build the ProductDetails table?
A. Use a For loop to concatenate all of the Products table and apply a Generic Load to the final concatenate table
B. Use a For loop to apply a Generic load to the Product table and concatenate the generic tables together
C. Use a Generic Load in the Product table and a For loop to left join each Generic table
正解：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