Qlik QSDA2022 Exam Practice Test Instant Access

Question 1

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)

AOption A

BOption B

COption C

DOption D

Answer : B

Question 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?

AAn Omit field has been applied

BSection access restricts too many records

CA security rule has been applied to the sheet object

DThe affected users were NOT added to the Section table

Answer : B

Section access restricts access to certain records, and if too many records are restricted, it can lead to incomplete visualizations. Source: Qlik

Section access is used to control access to the data in an app. If the section access settings are too restrictive, they can prevent certain users or teams from seeing all of the data they need, resulting in incomplete visualizations.

It is possible that the affected team has been assigned a section access that is too restrictive, preventing them from seeing all of the necessary data. This could be a misconfiguration or an oversight in the section access settings.

Question 3

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 4

A global retailer has a large database in which millions of sales transactions are added per hour.

Each regional sales manager should only see details for customers in their region. After filtering based on criteria such as region, gender, and income level, sales managers should be able to see the most current detailed transactions.

What should a data architect do to meet these requirements?

ACreate an app for each sales manager with Qlik GeoAnalytics

BUse section access and include a service account in the table

CUse On-Demand App Generation (ODAG) and section access

DUse section access to restrict sales manager access by region

Answer : D

Question 5

A data architect wants to combine data on present and historic sales performance. The historic data is stored in a de-normalized archive, and the present data is maintained in a database. The output must be contained in a single table.

Which script should the data architect use?

AOption A

BOption B

COption C

DOption D

Answer : C

Question 6

A data architect is creating an app using three tables. After executing the script, a warning displays

Which two steps should the data architect do to resolve this warning? (Select two.)

ARemove the rename statement (line 24) in the ProductPriceList table leaving the Product field name as is.

BRename the Category field in the ProductPriceLis table to PnceCategory (line 24).

CMove the preceding Load statement in line 10 between table name (line 23) and Load statement (line 24).

Dinsert 'Join (ProductDetails)' in front of the Load statement in line 24 to combine ProductPriceList with ProductDetails

Answer : B

Question 7

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

Qlik Sense Data Architect Certification Exam - 2022 QSDA2022 Exam Practice Test