QSDA2022 by Qlik Valid Free Exam Practice Test

Question 1

Refer to the exhibit.

This table contains information about the number of admissions and discharges of patients in a hospital. The values can be positive or negative. The data architect needs to create an extra column that contains the number of patients that are currently in the hospital.
Which script should the data architect use ?
A)

B)

C)

D)

A. Option B B. Option A C. Option D D. Option C

Correct Answer: B

Question 2

A data architect needs to develop a script to export tables from a model based upon rules from an independent file. Thestructure of the text file with the export rules is as follows:

These rules govern which table in the model to export, what the target root filename should be, and the number of copies to export.
The TableToExport values are already verified to existin the model.
In addition, the format will always be QVD, and the copies will be incrementally numbered.
For example, the Customer table would be exported as:
What is the minimum set of scripting strategies the data architect must use?

A. One loop and one SELECT CASE statement B. Two loopswithout any conditional statement C. Two loops and one IF statement D. One loop and two IF statements

Correct Answer: A

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 3

The Marketing department is using some similar KPIs in different apps that need to be modified frequently according to the business needs. The KPIs are created using master items with the same expression.
Which method should the data architect use to manage the modifications in all apps?

A. Create a variable repository and load them using INCLUDE statements in the apps where needed B. Create a core app with all the master items needed and use a BINARY load in the other apps. C. Create only a single app with allthe master items needed and protect it with SECTION ACCESS. D. Create a selection app with all the master items and use an on-demand app generation method.

Correct Answer: A

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 4

A data architect executes the following script:

What will Field_1 contain after this script is executed?

A. abcd B. Abed, abed, ABCD, ABCDABCD C. Abcd, abcd D. Abed, abed, ABCD

Correct Answer: D

Question 5

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

A. 1. 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 B. 1 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 C. 1 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 D. 1. 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

Correct Answer: A

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 6

A customer has a dataset that contains latitude and longitude data for service points around the country. The data is retrieved using the following statement:

It must be clear to the end user that this is geographic data. Drag and drop, map-based visualization of this data is required. Which two steps should the data architect take to support this data? (Select two.)

A. Add the following to the end of the script:
TAG FIELD LocationName With 'Sgeoname', *@relates_Pt';
TAG FIELD Point With 'Sgeopoint*f 'Srelates Location', '$hidden'; B. Add GeoProject{' Point' , Lat&Long) AS Point to the preceding load C. Add GeoKakePoint (Lat, Long} as Point to Location's preceding load D. Define Location as a master item, and set the tag to Sgeodata E. Add the following to the end of the script:
TAG FIELD LocationName With 'Sgeodata1, 'Srelated'; TAG FIELD Point With 'Sgeodata', 'Srelated1;

Correct Answer: A,B

Question 7

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 iscomposed 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. MID ( SUBFIELD (Key , ' ', 2), 3) B. LEFT(SUBFIELD(Key, ' ', 2), 2) C. LTRIM (SUBFIELD (Key, ' ', 2), 2) D. RIGHT(SUBFIELD (Key,' ', 2), 3)

Correct Answer: B

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 8

A human resources (HR) team manager is due to go on leave. The manager needs to assign permissions to colleague to help the HR team publish apps. Which action(s) should the manager assign to the colleague before going on leave?

A. Owner Publish, Read B. Owner Publish C. Publish, Read D. Publish

Correct Answer: B

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

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