Practice QSDA2022 Exam Online

Question 1

QSDA2021-page52-image15

A data architect is creating an app using three tables. After executing the script, a warning displays

Which two steps should the data architect do to resolve this warning? (Select two.)

A :

Remove the rename statement (line 24) in the ProductPriceList table leaving the Product field name as

is.

B : Rename the Category field in the ProductPriceLis table to PnceCategory (line 24).

C : Move the preceding Load statement in line 10 between table name (line 23) and Load statement (line 24).

D : insert "Join (ProductDetails)" in front of the Load statement in line 24 to combine ProductPriceList with ProductDetails

Answer: B

Question 2

Which component of the Qlik Sense suite is used to import application?

A : Qlik Management Console

B : Qlik Sense Desktop

C : Qlik Cloud Console

D : Qlik Sense Hub

Answer: A

Question 3

A data architect must break down a 13-character ShipmentID code in the following format: #-###-##-##-#. Separate fields must be created from the numeric values separated by the hyphen (-). The data architect must extract five sub-fields: ShipmentLoc, Quantity, CategoryID, StoreLoc and Division.

How should the data architect meet this requirement?

A : In the data load editor, load the ShipmentID field and apply the function: PurgeChar(ShipmentID,'-')

B : In the data manager, use the data profiling card to replace the '-' characters in the ShipmentID

C : In the data load editor, load the ShipmentID field and apply the KeepChar() and Trim() functions

D : In the data manager, use the data profiling card to split the ShipmentID by the '-' character

Answer: D

Question 4

Refer to the exhibit.

This table contains information about the number of admissions and discharges of patients in a hospital. The

values can be positive or negative. The data architect needs to create an extra column that contains the number

of patients that are currently in the hospital.

Which script should the data architect use ?

A : PatientData: LOAD Date:

LOAD

Data, PatientChange,

PatientChange + FieldValue (PatientChange) AS #Patients

FROM :[lib://Data/PatientData.xlsx]

(ooxmi, embedded labeLs, table is Sheetl) ;

B : PatientData:

LOAD

Date, PatientChange,

Above(PatientChange) AS #Patients

FROM :[lib://Data/PatientData.xls]

(ooxmi, embedded labeLs, table is Sheet1) ;

C : PatientData:

LOAD

Date, PatientChange,

RangeSum (PatientChange, Peek(#Patients)) AS #Patients

FROM :[lib://Data/PatientData.xlsx]

(ooxmi, embedded labeLs, table is Sheetl);

D : PatientData:

LOAD

Date, patientChange,

PatientChange + Feek/PatientChange) AS #Patients

FROM [lib://Data/PatientData.xlsx]

(ooxmL, ericedded labels, table is Sheet1);

Answer: C

Question 5

A data architect builds a data model for a large user group. Some sheets will be published, and the app will

allow users to create their own visualizations and analyze data. Some fields must NOT appear in any field list.

How should a data architect meet these requirements?

A : Use HidePrefix variable

B : Add fields to master items

C : Use security rules

D : Use HideField variable

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