Qlik QSDA2022 Exam Practice Test Instant Access

Question 1

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?

AFileSize, IF, THEN, END IF

BFilePath, IF, THEN. Drop

CFileExists, FOR EACH, IF

DFilePath, FOR EACH, Peek, Drop

Answer : A

Question 2

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 app is 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?

AUse the data manager

BLoad a calendar island

CCreate a canonical calendar

DCreate five master calendars

Answer : C

Question 3

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?

A1. Create a link table with master calendar fields
2. Create a single filter using fields from the master calendar

B1. Load the Shipments and Orders table via the data manager
2. Create a single filter using fields from the Orders table

C1. Create a master calendar and join into the Shipments and Orders table
2. Create a single filter using fields from the Shipments table

D1. Create a master calendar table as a data island
2. Create a single filter using fields from the master calendar

Answer : A

Question 4

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 is composed 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.

ALTRIM (SUBFIELD (Key, ' ', 2), 2)

BMID ( SUBFIELD (Key , ' ', 2), 3)

CRIGHT(SUBFIELD (Key,' ', 2), 3)

DLEFT(SUBFIELD(Key, ' ', 2), 2)

Answer : D

This expression will extract the unique code from the key by using the SUBFIELD function to separate the key into its components, and then using the LEFT function to extract the first two characters of the second component. Source: Qlik

Question 5

A data architect executes the following script:

What will be the result of Table A?

AOption A

BOption B

COption C

DOption D

Answer : D

Question 6

A data architect needs to create an app that combines employee data from the Sales system and the Human Resources (HR) system.

These systems identify employees differently Employees in the HR system are identified with an alpha-numeric key Employees in the Sales system are identified using an integer key.

The Human Resources manager creates a table that maps these keys to another, called Associations.

The resultant data model must meet the following requirements:

* Associations must be valid

* The model must be optimized for performance

* The option must support multiple tables added

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

AAPPLYMAP ( 'Associations , EmployeeKey ) as Employeekey;

BMAPSUBSTRING ( 'Associations' ,EMployeekey) As Employeekey;

CMAP EmloyeeKey USING Associations;

DRENAME FIELDS USING Associations;

Answer : C

The MAP function maps the EmployeeKey in the Sales system to the EmployeeKey in the HR system using the Associations table. This allows the data architect to join the data from the Sales system and the HR system using the same key, ensuring that the associations are valid.

Using the MAP function also optimizes the performance of the data model as it eliminates the need for multiple joins between the data from the Sales and HR systems.

This solution also supports multiple tables added, as the MAP function can be applied to any table that needs to be joined with the HR system data.

Question 7

Refer to the exhibits.

Some business users created an app by using the Add data functionality and loading two Excel files Orders and Customers.

The app is used to analyze the number of orders by customer. When the users create a bar chart to review the figures, the data shown is incorrect.

What should the data architect do to resolve this issue?

AOpen the data manager, split the Customers table, and associate both tables on CustomerlD field

BOpen the data manager, split the Customers table, and JOIN Orders and Customers on the CustomerlD field

COpen the data load editor and use JOIN instead of concatenate to combine Orders and Customers by CustomerlD

DOpen the data load editor and apply a NOCONCATENATE function in the LOAD statement on the Orders table

Answer : C

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