Qlik QSDA2022 Exam Questions Instant Access

Question 1

A data architect needs to develop a script to export tables from a model based upon rules from an independent file. The structure 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 exist in 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?

ATwo loops without any conditional statement

BOne loop and two IF statements

CTwo loops and one IF statement

DOne loop and one SELECT CASE statement

Answer : D

The data architect will need to use a single loop to iterate through the rows of the independent file containing the export rules. Within the loop, they will need to use a SELECT CASE statement to determine which table in the model to export based on the TableToExport value in the current row of the independent file. They can then use the StoreAsFilename value to determine the target root filename, and the NumberOfCopies value to determine the number of copies to export.

This approach makes use of a single loop to iterate through the rows of the independent file, and a SELECT CASE statement to determine which table to export based on the TableToExport value in the current row. It is the most efficient way to accomplish the task with minimal scripting.

You can find the Qlik scripting documentation for Store statement here: https://help.qlik.com/en-US/sense/June2020/Subsystems/Hub/Content/Scripting/ScriptPrefixes/Store.htm and SELECT CASE statement here: https://help.qlik.com/en-US/sense/June2020/Subsystems/Hub/Content/Scripting/ScriptStatements/Select.htm

Question 2

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 a QVD file. The data architect wants to load the records into Qlik Sense efficiently.

Which steps should the data architect take to meet these requirements?

A1 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

B1. Load the existing data from the QVD
2. Load new and updated 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

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

D1 Load the 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. Load all records from the key field from the database and use an INNER JOIN on the previous table.

Answer : D

Question 3

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 4

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?

ACreate a bridge table between the Departments and Salespeople tables to resolve the many-to-many relationship

BCreate a bridge table between the Transactions and Salespeople tables to resolve the many-to-many relationship

CJoin the Departments and Salespeople tables to resolve the many-to-many relationship

DJoin the Transactions and Salespeople tables to resolve the many-to-many relationship

Answer : A

Question 5

Multiple department fields in a dataset require a description

A data architect needs to add the department descriptions or a default value when the department does NOT have a description

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

AApplyMap with two parameters after the Mapping load

BLeft Join between tables and Description xlsx in every Department table

CEnter 'Missing description' in the blank rows for Description xlsx then Mapping Load

DApplyMap with three parameters after the Mapping load

Answer : D

This strategy involves using the ApplyMap function with three parameters after the Mapping load. This will allow the data architect to add the department descriptions or a default value when the department does not have a description. Source: Qlik

Question 6

Refer to the exhibit

A data architect is working on an app that contains orders, invoices, and shipping dat

a. There are three different date fields within the data:

* OrderDate

* InvoiceDate

* ShippingDate

The business analyst needs to replicate the chart above to show Order and Shipping amounts on the same Month axis.

What should the data architect do?

ACreate a Month field for each of the three dates in the fact table and use that in the chart

BLoad the key field and the three date fields into a concatenated bridge table that contains KeyField and Date

CLeft Join the three date fields onto one bridge table using the key field containing KeyField and Date

Answer : B

Question 7

A data architect executes the following script:

What will Field_1 contain after this script is executed?

AAbed, abed, ABCD

Babcd

CAbcd, abcd

DAbed, abed, ABCD, ABCDABCD

Answer : A

Qlik Sense Data Architect Certification Exam - 2022 QSDA2022 Exam Questions