QSDA2022 Exam Dumps - Qlik Sense Data Architect Questions and Answers

Page: 1 / 2

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

Options:

LTRIM (SUBFIELD (Key, ' ', 2), 2)

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

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

LEFT(SUBFIELD(Key, ' ', 2), 2)

Buy Now

Questions 5

A data architect needs to upload different data sources. To properly handle null values, the data architect decides to set all of these values to "Missing Value".

Which syntax should the data architect use?

Options:

NullAsValue*; Set NullValues = 'Missing Value';

NullasNull *;

Set NullValues = 'Missing Value';

NullasNull *;

Set NullValue = 'Missing Value';

NullAsValue*;

Set NullValue = 'Missing Value';

Buy Now

Questions 6

Refer to the exhibit.

A data architect builds a simple data model to show the relationship between students and exams. The data is loaded. Every StudentID in the Exams table should be found in the Students table. Some students have NOT taken an exam.

The data architect selects the field "StudentID" from the Students table and sees the following: