Qlik Sense Data Architect Certification Exam - 2022

QUESTION NO: 1
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 On-Demand App Generation (ODAG) and section access C. Use section access and include aservice account in the table D. Use section access to restrict sales manager access by region

Correct Answer: D

QUESTION NO: 2
A company needs to analyze sales data based on the exchange rate of the different countries every day About
30 reports must be produced with an average of 20r000 rows each. This process is estimated to take about three hours.
Reports will be in Excel and distributed to business users according to defined security rules Which two products should the data architect use to build this solution? (Select two.)

A. QIik NPrinting B. ODAG C. Qlik Storytelling D. OQIikGeoAnalytics E. QIikDataMarket

Correct Answer: A,B

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

QUESTION NO: 3
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?

A. A synthetic table and one synthetic key B. A synthetic table with two synthetic keys C. A synthetic table with three synthetic keys D. A circular reference with one table disconnected

Correct Answer: D

QUESTION NO: 4
A data architect needs to efficiently prepare a data model for a meeting in an hour.
The data source to be used contains five date fields The app needs to display sales trends and compare the current year to date (CYTD) to last year to date (LYTD) The appis NOT going to be published It will only be used for this meeting and a single user's ad-hoc analysis.
What should the data architect do to meet these requirements?

A. Create a canonical calendar B. Load a calendar island C. Use the data manager D. Create five master calendars

Correct Answer: A

QUESTION NO: 5
A data architect of an organization that has implemented Qlik Sense on Windows needs to load large amounts of data from a database that is continuously updated New records are added, and existing records get updated and deleted. Each record has a LastModified field.
All existing records are exported into aQVD file. The data architect wants to load the records into Qlik Sense efficiently.
Which steps should the data architect take to meet these requirements?

A. 1 Load the existing data from the QVD
2. Load the new and updated data from the database without the rows that have just been loaded from the QVD and concatenate with data from the QVD
3. Load all records from the key field from the database and use an INNER JOIN on the previous table B. 1. Use a partial LOAD to load new and updated data from the database.
2.Load the existing data from the QVD without the updated rows that have just been loaded from the database and concatenate with the new and updated records
3. Use the PEEK function to remove the deleted rows C. 1 Load the new and updated data fromthe database.
2. Load the existing data from the QVD without the updated rows that have just been loaded from the database and concatenate with the new and updated records.
3. Load all records from the key field from the database and use an INNER JOIN onthe previous table. D. 1. Load the existing data from the QVD
2. Load new andupdated data from the database Concatenate with the table loaded from the QVD.
3. Create a separate table for the deleted rows and use a WHERE NOT EXISTS to remove these records

Correct Answer: C

QUESTION NO: 6
Refer to the exhibit.

The data architect needs to build a model that contains Sales and Budget data for each customer.
Some customers have Sales without a Budget, and other customers have a Budget with no Sales During loading, the data architect resolves a synthetic key by creating the composite key For validation, the data architect creates a table containing Customer, Month. Sales, and Budget columns.
What does the data architect see when selecting a month?

A. All Customers, all Budget and all Sales records B. Customer, Sales, and Budget records for that month C. Customer and Budget records for that month, but missing values for Sales D. Customer and Sales records for that month, but missing values for Budget

Correct Answer: B

QUESTION NO: 7
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. Publish, Read C. Owner Publish D. Publish

Correct Answer: C

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

QUESTION NO: 8
Refer to the exhibit.

What are the values of the variables vLoadStart and vLoadComplete after the script executes?

A. vLoadStart: current system date and time when the script started vLoadComplete: 'now()' B. vLoadStart: system date when the app was opened vLoadComplete 'now()' C. vLoadStart: system date when the app was opened vLoadComplete: current system date and time when the script ended D. vLoadStart; 'NOW{)'
vLoadComplete: current system date and time when the script ended

Correct Answer: A

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

Qlik Sense Data Architect Certification Exam - 2022 - QSDA2022 Exam Questions