Qlik QSDA2021 - Qlik Sense Data Architect Certification Exam - February 2021 Release
Refer to the exhibit.
A data architect is loading two tables into a data model from a SQL database These tables are related on key fields CustomerlD and CustomerKey.
Which script is valid to load the tables and maintain the correct association?
A)
B)
C)
D)
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?
Refer to the exhibit.
A data architect executes the script.
What will be the value of the first row for Field_1?
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 data architect executes the following script.
Which values does the OrderDate field contain after executing the script?
ITALY IT001 HR
GERMANY DE002 HR
SPAIN SP03 FINANCE
FRANCE FRO04 SALES
Refer to the exhibit
A company stores the employee data within a key composed of Country UserlD, and Department. These fields are separated by a blank space. The UserlD field is composed of two characters that indicate the country followed by a unique code of two or three digits. A data architect wants to retrieve only that unique code.
A data architect needs to write the expression for a measure on a KPI to show the sales person with the highest sales The sort order of the values of the fields is unknown When two or more sales people have sold the same amount, the expression should return all of those sales people
Which expression should the data architect use?
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)
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 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)
