Qlik QSDA2022 Exam Practice Test Instant Access

Question 1

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 2

On executing a load script of an app, the country field needs to be normalized. The developer uses a mapping table to address the issue.

What should the data architect do?

AUse a LEFT JOIN instead of the APPLYMAP

BUse LOAD DISTINCT on the mapping table

CCreate two different mapping tables

DReview the values of the source mapping table

Answer : D

Question 3

Refer to the exhibit.

A data architect is working on a Qlik Sense app the business has created to analyze the company orders and shipments. To understand the table structure, the business has given the following summary:

* Every order creates a unique orderlD and an order date in the Orders table

* An order can contain one or more order lines one for each product ID in the order details table

* Products in the order are shipped (shipment date) as soon as tliey are ready and can be shipped separately

* The dates need to be analyzed separately by Year Month, and Quarter

The data architect realizes the data model has issues that must be fixed.

Which steps should the data architect perform?

A1. Create a key with OrderlD and ProductID in the OrderDetails table and in the Orders table
2. Delete the ShipmentID in the Shipments table
3. Delete the ProductID and OrderlD in the OrderDetails table
4. Concatenate Orders and OrderDetails
5. Create a link table using the MasterCalendar table and create a concatenated field between OrderDate and ShipmentDate

B1. Create a key with OrderlD and ProductID in the OrderDeta Is table and in the Shipments table
2. Delete the ShipmentID in the Orders table
3. Delete the ProductID and OrderlD in the Shipmi
4. Left join Orders and OrderDetails
5. Use Derive statement with the MasterCalendar table and apply the derive fields to OrderDate and ShipmentDate

C1. Create a key with OrderlD and ProductID in the OrderDetails tab e and in the Orders table
2. Delete the ShipmentID in the Shipments table
3. Delete the ProductID and OrderlD in the OrderDetails
4. Left join Orders and OrderDetails
5. Use Derive statement with the MasterCalendar table and apply the derive fields to OrderDate and ShipmentDate

D1. Create a key with OrderlD and ProductID in the OrderDetails table and in the Shipments table
2. Delete the ShipmentID in the Orders table
3 Delete the ProductID and OrderlD in the Shipments table
4. Concatenate Orders and OrderDetails

Answer : D

Question 4

Refer to the exhibit.

A data architect is working with an app and creates some visualizations to check the dat

a. Some visualizations show issues in the data set.

* The Sales by Country table shows a total OrderValue of 18,300 sales while the KPI shows a total OrderValue of 20,600.

* The Sales monthly trend bar chart does not work with the Month field.

Which two data issues should the data architect fix in the app? (Select two.)

AThe Month field does not exist in the Orders table and needs to be incorporated in the table using he Calendar table.

BIn the Orders table, some CustomerlD values are null because there are orders with no customer.
and needs to be incorporated in the table using the Calendar table, null because there are orders with no customer

CIn the Orders table, some values in the CustomerlD field do not exist in the Customers table.

DThe OrderDate field values in the Calendar table do not match with the values in the OrderDate field from the Orders table

Answer : C, D

Question 5

Refer to the exhibit.

A data architect must classify each product into a price group. The price groups must be the same width by default and allow users to dynamically change the width of the bucket during analysis.

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

AClass function in the script and use variables

BClass function in a calculated dimension

CNested IFs in a calculated dimension

DIntervalMatch and use variables

Answer : B

Question 6

A company has different departments. Executive and Sales should always be the first values in a Department filter pane. Which script must the data architect use to meet this requirement?

AOption A

BOption B

COption C

DOption D

Answer : D

Question 7

Refer to the exhibit.

While performing a data load from the source shown, the data architect notices it is NOT appropriate for the required analysis.

The data architect runs the following script to resolve this issue:

Answer : D

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