Practice QSDA2022 Exam Online

Question 1

Referring to the image. The Country field in a CRM application is a free writing text field. More variations in spelling and countries are expected in the future for the same reason. A data architect must create a field called CountryCode based on the value in the Country field.

What script should the data architect create to perform this task?

2021-10-15-02-55-00-22f383eea591fecc399d82864f01e7cb

A :

LOAD

Name,

If( Left( Country, 1) = 'U', 'USA', 'FRA') as CountryID

…

B :

CountryID:

Mapping Load* Inline [

Country, CountryID

USA, USA

US, USA

U.S.A., USA

France, FRA

];

Persons:

Join LOAD

Name,

Country

…

C :

LOAD

Name,

Pick( Match( Country, 'USA', 'US', 'U.S.A.', 'France), 'USA', 'USA', 'USA', 'FRA') as CountryID

…

D :

CountryID:

Mapping Load* Inline [

Country, CountryID

USA, USA

US, USA

U.S.A., USA

France, FRA

];

Persons:

LOAD

Name,

ApplyMap('CountryID', Country, 'UNK') as CountryID

…

Answer: D

Question 2

What is the correct syntax to remove a field from a table

A : REMOVE < fieldname > FROM < tablename >

B : DROP FIELD < fieldname > FROM TABLE < tablename >

C : DROP < fieldname > FROM < tablename >

D : DROP FIELD < fieldname > FROM < tablename >

Answer: D

Question 3

According to the image, what is the relationship between data models 1 and 2?

2021-10-15-02-11-54-cd7f3d25493b69c28226441138770275

A : The Snow-Flake schema model has been normalized to Single table model

B : The Star-Schema model has been normalized to a Single table model

C : Data Model 1 has been de-normalized to form Data Model 2

D : Data Model 1 has been normalized to form Data Model 2

Answer: C

Question 4

What is this script snippet doing?

FOR i = 0 to NoOfTables() -1

LET t = TableName(i);

STORE [$(t)] INTO [lib://Folder/$(t)].qvd;

NEXT;

A : Concatenating all existing tables in the data model to a single QVD file

B :

Storing the names of all existing tables in the model in a single file

C : Creating a QVD file for each existing table in the data model

D : Is removing all tables from the data model through a repeating loop

Answer: C

Question 5

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?

A : APPLYMAP ( 'Associations , EmployeeKey ) as Employeekey;

B : MAPSUBSTRING ( 'Associations' ,EMployeekey) As Employeekey;

C : MAP EmloyeeKey USING Associations;

D : RENAME FIELDS USING Associations;

Answer: C

Name:	Qlik Sense Data Architect
Exam Code:	QSDA2022
Certification:	Qlik Sense
Vendor:	QlikView
Total Questions:	168
Last Updated:	Apr 24, 2024

QlikView QSDA2022