Free Online QlikView QSDA2022 Practice Test

Prepare Your QlikView QSDA2022 Exam Questions with Free online QSDA2022 Practice Test. Get Brilliant Qlik Sense Data Architect Exam Results with Valid QSDA 2022 Exam Dumps.

Page: 1 / 34

Total 168 Questions | Updated On: May 14, 2024

Add To Cart

Question 1

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 2

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

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 3

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:LOADData, PatientChange,PatientChange + FieldValue (PatientChange) AS #PatientsFROM :[lib://Data/PatientData.xlsx] (ooxmi, embedded labeLs, table is Sheetl) ;

B : PatientData:LOADDate, PatientChange,Above(PatientChange) AS #PatientsFROM :[lib://Data/PatientData.xls](ooxmi, embedded labeLs, table is Sheet1) ;

C : PatientData:LOADDate, PatientChange,RangeSum (PatientChange, Peek(#Patients)) AS #Patients FROM :[lib://Data/PatientData.xlsx](ooxmi, embedded labeLs, table is Sheetl);

D : PatientData:LOADDate, patientChange,PatientChange + Feek/PatientChange) AS #PatientsFROM [lib://Data/PatientData.xlsx](ooxmL, ericedded labels, table is Sheet1);

Answer: C

Question 4

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 5

Given a database field name as Group_Num, you are prompted to rename it so that after each occurrence of Group_Num in the data model, the field must be renamed to GroupID automatically. How would you do it?

A : Use 'As' in every table

B : Use 'Alias' function

C : Use 'SubField' function

D : Use 'Rename' function

Answer: B

Page: 1 / 34

Total 168 Questions | Updated On: May 14, 2024

Add To Cart