Qlik QSDA2022 Exam Practice Test Instant Access

Question 1

A data architect completes development of a new app with two data sources Both data sources will also be used by other apps in the future The sources have different data refresh frequencies

* Source 1 Contains frequently updated data and must be refreshed hourly

* Source 2 Contains data that is transferred from a partner and must be refreshed weekly

Tasks must be created to load the data sources and make sure that the new app uses the most current data The data will be stored in two QVDs Which tasks should be created to meet these requirements'?

A1 Schedule Task 1 to run hourly and refresh data from Source 1
2 Schedule Task 2 to run weekly and refresh data from Source 2
3. Schedule a task for the app that is dependent on completion of Tasks 1 or 2 that loads the two QVDs

B1. Schedule Task 1 to run hourly and refresh data from Source 1
2 Schedule Task 2 that is dependent on Task 1 to refresh data from Source 2
3. Schedule a task for the app that is dependent on completion of Task 2 that loads the two QVDs

C1. Schedule Task 1 to run hourly and refresh data from Source 1
2 Schedule Task 2 that is dependent on Task 1 to refresh data from Source 2
3 Schedule a task for the app that is dependent on completion of Tasks 1 and 2 that loads the two QVDs

D1 Schedule Task 1 to run hourly and refresh data from Source 1
2 Schedule Task 2 to run weekly and refresh data from Source 2
3. Schedule a task for the app that is dependent on completion of Task 2 that loads the two QVDs

Answer : C

This option ensures that the data in the two data sources is always up-to-date by scheduling the data refresh tasks to run at the appropriate frequencies. Task 1 runs hourly to refresh data from Source 1, and Task 2 is dependent on Task 1 so that it runs only after Task 1 is completed. This ensures that the data from Source 2 is loaded only after the most current data from Source 1 is loaded.

Question 2

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 3

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 4

Refer to the exhibits.

Some business users created an app by using the Add data functionality and loading two Excel files Orders and Customers.

The app is used to analyze the number of orders by customer. When the users create a bar chart to review the figures, the data shown is incorrect.

What should the data architect do to resolve this issue?

AOpen the data manager, split the Customers table, and associate both tables on CustomerlD field

BOpen the data manager, split the Customers table, and JOIN Orders and Customers on the CustomerlD field

COpen the data load editor and use JOIN instead of concatenate to combine Orders and Customers by CustomerlD

DOpen the data load editor and apply a NOCONCATENATE function in the LOAD statement on the Orders table

Answer : C

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 exhibits.

While debugging an app, a developer loads data from an application layer QVD file.

In the process of separating a concatenated key into two parts, some split results are missing data

What should the data architect do?

A) Utilize a combination of LEFT(), MID(), and RIGHT() functions to capture the key components

B) In the SUBFIELD function, replace the '_' with a '|' or '_' character.

While debugging an app, a developer loads data from an application layer QVD file.

In the process of separating a concatenated key into two parts, some split results are missing data

What should the data architect do?

AUtilize a combination of LEFT(), MID(), and RIGHTO functions to capture the key components

BIn the SUBFIELD function, replace the '- with a '|' or '-' character

CInstruct the developer of the QVD file to correct the generation of the ConcatKeyAlpha field

DWrap an IF() function around the SUBFIELDQ functions to check and adapt to null values character

EInstruct the developer of the QVD file to correct the generation of the ConcatKeyAlpha field

FWrap an IF() function around the SUBFIELD() functions to check and adapt to null values

Answer : D

Question 7

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?

ASection access and set analysis

BQMC security rules and section access

CQMC security rules and custom properties

DSection access and sheet properties

Answer : B

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