Free QSDA2022 Exam Dumps PDF Preview

Question 1

Single choice

Refer to the exhibit.

An existing app on Qlik Sense Enterprise is duplicated and transferred to a data architect to add some additional data When trying to manually reload the original script, the data architect receives an error

What should be done to make sure the script runs correctly?

A
Add the line lib connect to 'QVD(abc_qservice/orderData.qvd) '; before the LOAD for the Order Data
table
B
Add the line lib connect to ' SQL (abc_qs9rvi.es) ` ;before the LOAD for the Order Detail table
C
Give the data architect the Read rights on the data connections in the QMC
D
Make the data architect the owner of the app in the QMC

Reveal answer details Close answer details

Correct answerC

Question 2

Single choice

A data architect needs to build an Order Fulfillment app. The business requires front-end performance is optimized.

The OrderDate and ShipmentDate are located in different tables.

The user needs to identify the data type and must be able to:

Show trends for orders and shipments
Use a single filter for both date fields Analyze data over fiscal periods

Which steps should the data architect take to build the data model?

A
1. Create a link table with master calendar fields
2. Create a single filter using fields from the master calendar
B
1. Load the Shipments and Orders table via the data manager
2. Create a single filter using fields from the Orders table
C
1. Create a master calendar and join into the Shipments and Orders table
2. Create a single filter using fields from the Shipments table
D
1. Create a master calendar table as a data island
2. Create a single filter using fields from the master calendar

Reveal answer details Close answer details

Correct answerA

Question 3

Multiple choice

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
Define Location as a master item, and set the tag to Sgeodata
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
Add the following to the end of the script:
TAG FIELD LocationName With 'Sgeodata1, 'Srelated'; TAG FIELD Point With 'Sgeodata', 'Srelated1;
E
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';

Reveal answer details Close answer details

Correct answersB, E

Question 4

Single choice

Refer to the exhibits.

An app is built to analyze salesperson performance by department. Departments are unique within the Departments table, but Salespeople often move between departments. A strict business rule states that a

salesperson must be associated with ONLY one department at all times.

The data architect creates a summary of department performance and notices the values are incorrect.
The total sales KPI shows the correct result.

How should the data architect modify the data model to correct this issue?

A
Create a bridge table between the Departments and Salespeople tables to resolve the many-to-many relationship
B
Create a bridge table between the Transactions and Salespeople tables to resolve the many-to-many relationship
C
Join the Departments and Salespeople tables to resolve the many-to-many relationship
D
Join the Transactions and Salespeople tables to resolve the many-to-many relationship

Reveal answer details Close answer details

Correct answerA

Question 5

Single choice

A table is generated resulting from the following script

When the data architect selects a date, some, but NOT all, orders for that date are shown How should the data architect modify the script to show all orders for the selected date? A)

B.

C.

D.

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

Reveal answer details Close answer details

Correct answerC

Question 6

Single choice

A data architect needs to develop multiple apps for various departments. More departments are requesting apps over time The company uses specific requirements for the number interpretation variables (e.g.,

ThousandSep, DecimalSep) found at the beginning of a LOAD script.

The data architect wants to reduce duplicate scripts but does not want to copy and paste the number interpretation variables each time new app is created. The data architect prefers to use the least amount of script in Qlik Sense.

How should the data architect meet these requirements?

A
Save the script for the number interpretation variables in a text file and use the CALL function to insert the variables.
B
Create an Excel file with the number interpretation variables and use a FOR Next loop to load the variables into Qlik Sense
C
Save the script for the number interpretation variables in a text file and INLUDE function to insert the variables
D
Create an Excel file with the number interpretation variables and apply the variables to the app using a mapping table

Reveal answer details Close answer details

Correct answerC

Explanation

Explanation: This method involves saving the script for the number interpretation variables in a separate text file, and then using the INCLUDE function to insert the variables into each new app script that is created. This reduces the need to copy and paste the number interpretation variables each time a new app is created and allows the data architect to use the least amount of script in Qlik Sense.
The INCLUDE function is a script statement that allows you to insert the contents of one script file into another script file. This can be used to insert common scripts, such as the number interpretation variables, into multiple app scripts.

Question 7

Single choice

Refer to the exhibit.

A data architect loads sales data and creates a table which shows only customers who made purchases in 2018 and 2019. The data architect applies the following set analysis expression on the sales measure.
Count<{<Year={'2 018'}, CustomerID=P({<Year={'2019*}>})>} Customer ID)

Which option shows the resulting table after the expression is applied?

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

Reveal answer details Close answer details

Correct answerD

Question 8

Single choice

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?

A
Create an app for each sales manager with Qlik GeoAnalytics
B
Use section access and include a service account in the table
C
Use On-Demand App Generation (ODAG) and section access
D
Use section access to restrict sales manager access by region

Reveal answer details Close answer details

Correct answerD

Question 9

Single choice

A data architect needs to create an app to analyze 30-day re-admissions at a hospital.

The medical record system does NOT calculate re-admission data
The business rule to follow: if a patient is admitted to a hospital within 30 days after being discharged from a previous hospital stay, that event should be captured in the app with a flag called "30-day Re-admission"
Data being used from the patient record includes hospital account ID, patient ID, admission dater and discharge date

Which action should the data architect perform first to meet these requirements?

A
Sequence patient records by hospital account ID and patient ID using the Peek function
B
Sequence patient records by patient ID using the Peek function
C
Calculate the days since previous discharge using admission date and discharge date
D
Order patient records by patient ID and admission date

Reveal answer details Close answer details

Correct answerD

Question 10

Single choice

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?

A
Use where exists (ID, StorelD)
B
Use where exists (ID)
C
Use Concatenate before loading the Stores table

Reveal answer details Close answer details

Correct answerB

Question 11

Single choice

A data architect needs to upload data from ten different sources, but only if there are any changes after the last reload When data is updated, a new file is placed into a folder mapped to E A439926003.
The data connection points to this folder.

The data architect plans a script which will:

1. Verify that the file exists

2. If the file exists, upload it Otherwise, skip to the next piece of code

The script will repeat this subroutine for each source. When the script ends, all uploaded files will be removed with a batch procedure.

Which option should the data architect use to meet these requirements?

A
FileSize, IF, THEN, END IF
B
FilePath, IF, THEN. Drop
C
FileExists, FOR EACH, IF
D
FilePath, FOR EACH, Peek, Drop

Reveal answer details Close answer details

Correct answerA

Question 12

Single choice

Refer to the exhibit.

USER1 has an app protected using this Section Access statement.

Which countries can USER1 see in the app''

A
Germany. Italy, United Kingdom, The Netherlands
B
Italy, The Netherlands
C
Italy, United Kingdom, The Netherlands
D
Germany Italy, The Netherlands

Reveal answer details Close answer details

Correct answerC

Free QSDA2022 Exam Dumps Preview

Qlik Sense Data Architect Certification - 2022

PREVIEW CONTENTS · 2 VOLUMES

QUESTION 1

QUESTION 2

QUESTION 3

QUESTION 4

QUESTION 5

QUESTION 6

QUESTION 7

QUESTION 8

QUESTION 9

QUESTION 10

QUESTION 11

QUESTION 12

VOL	TYPE	QUESTIONS
1	Single choice	11
2	Multiple choice	1