Qlik QSDA2022 Exam Questions Instant Access

Question 1

Refer to the exhibit

A data architect develops an app for Coffee4all, a coffee company with stores located throughout Europe

The script runs successfully, but the Stores table does not have any values.

What should the data architect do?

AUse where exists (ID, StorelD)

BUse where exists (ID)

CUse Concatenate before loading the Stores table

Answer : B

Question 2

A data architect executes the following script.

Which values does the OrderDate field contain after executing the script?

A20210131, 2020/01/31, 31/01/2019, 0

B20210131,2020/01/31,31/01/2019

C20210131, 2020/01/31, 31/01/2019, 9999

D20210131, 2020/01/31, 31/01/2019, 31/12/20

Answer : D

Question 3

Refer to the exhibits.

The first table, Mastersports, contains the master list of all sport names that need to be loaded into the app. The second table, TeamMembers, contains the teams and team members registered for specific sports.

In a Qlik Sense app, a data architect is loading the two tables that need to be linked together based on the Sport field. The table format cannot be changed in the source.

What should the data architect do in the data load editor?

AApply a preceding LOAD from the TeamMembers table with the SUBFIELD function and rename the field to Sport

BApply a preceding LOAD to the MasterSports table with the SUBFIELD function to create the Sport field

CApply a FOR loop to load to the MasterSports table creating the values for the Sport field

Answer : C

Question 4

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?

AFirstSortedValue (Salesperson, -Aggr (Sum(Sales) , Salesperson) )

BConcat(DISTINCT IF (Aggr (Rank (Sum (Sales) , 4) , Salesperson) =1, Salesperson) , ' ')

CFirstSortedValue (DISTINCT Salesperson, -Aggr (Sum(Sales) , Salesperson) )

DConcat (DISTINCT IF (Aggr (Rank (Sum (Sales) , 1) , Salesperson) =1, Salesperson) , ' ')

Answer : D

Question 5

Refer to the exhibit.

Which changes on the database will the script capture?

AInsert and Remove rows

BInsert. Update, and Remove rows

CInsert and Update rows

DUpdate and Remove rows

Answer : B

Question 6

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?

AUse a For loop to concatenate all of the Products table and apply a Generic Load to the final concatenate table

BUse a For loop to apply a Generic load to the Product table and concatenate the generic tables together

CUse a Generic Load in the Product table and a For loop to left join each Generic table

Answer : C

Question 7

Refer to the exhibit.

A data architect needs to add a Budget table to the current Qlik Sense app. A Budget table with the fields Budget, CustomerlD, and ProductlD is loaded into the model. What will be created?

AA circular reference with one table disconnected

BA synthetic table with two synthetic keys

CA synthetic table with three synthetic keys

DA synthetic table and one synthetic key

Answer : A

Qlik Sense Data Architect Certification Exam - 2022 QSDA2022 Exam Questions