Qlik QSDA2022 問題集

質問 1：
A data architect needs to upload different data sources. To properly handle null values, the data architect decides to set all of these values to "Missing Value".
Which syntax should the data architect use?
A. NullasNull *;
Set NullValue = 'Missing Value';
B. NullasNull *;
Set NullValues = 'Missing Value';
C. NullAsValue*;
Set NullValue = 'Missing Value';
D. NullAsValue*; Set NullValues = 'Missing Value';
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 2：
A data architect of an organization that has implemented Qlik Sense on Windows needs to load large amounts of data from a database that is continuously updated New records are added, and existing records get updated and deleted. Each record has a LastModified field.
All existing records are exported into aQVD file. The data architect wants to load the records into Qlik Sense efficiently.
Which steps should the data architect take to meet these requirements?
A. 1. Use a partial LOAD to load new and updated data from the database.
2.Load the existing data from the QVD without the updated rows that have just been loaded from the database and concatenate with the new and updated records
3. Use the PEEK function to remove the deleted rows
B. 1 Load the existing data from the QVD
2. Load the new and updated data from the database without the rows that have just been loaded from the QVD and concatenate with data from the QVD
3. Load all records from the key field from the database and use an INNER JOIN on the previous table
C. 1. Load the existing data from the QVD
2. Load new andupdated data from the database Concatenate with the table loaded from the QVD.
3. Create a separate table for the deleted rows and use a WHERE NOT EXISTS to remove these records
D. 1 Load the new and updated data fromthe database.
2. Load the existing data from the QVD without the updated rows that have just been loaded from the database and concatenate with the new and updated records.
3. Load all records from the key field from the database and use an INNER JOIN onthe previous table.
正解：D

質問 3：
Refer to the exhibit.

A data architect must classify each product into a price group. The price groups must be the same width by default and allow users to dynamically change the width of the bucket duringanalysis.
Which feature should the data architect use to meet these requirements?
A. Class function in the script and use variables
B. IntervalMatch and use variables
C. Nested IFs in a calculated dimension
D. Class function in a calculated dimension
正解：D

質問 4：
A data architect builds a data model for a large user group. Some sheets will be published, and the app will allow users to create their own visualizations and analyze data. Some fields must NOT appear in any field list.
How should a data architect meet these requirements?
A. Use security rules
B. Add fields to master items
C. Use HidePrefix variable
D. Use HideField variable
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 5：

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 Generic Loadin the Product table and a For loop to left join each Generic table
B. Use a For loop to concatenate all of the Products table and apply a Generic Load to the final concatenate table
C. Use a For loop to apply a Generic load to the Product table and concatenate the generic tables together
正解：A

質問 6：
Refer to the exhibit.

A data architect is loading the tables and a synth key is generated.
How should the data architect resolve the synthetic key?
A. Create a composite key using OrderlD and LineNo. and remove OrderlD and LineNo from Shipments
B. Remove the LineNo field from both tables and use the AutoNumberfunction on the OrderlC field
C. Create a composite key using OrdertD and LineNo
D. Remove the LineNo field from Shipments and use the AutoNumber function on the
正解：A