Qlik QSDA2019 Exam Practice Test Instant Access

Question 1

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?

ANullAsValue*; Set NullValues = 'Missing Value';

BNullasNull *;
Set NullValues = 'Missing Value';

CNullasNull *;
Set NullValue = 'Missing Value';

DNullAsValue*;
Set NullValue = 'Missing Value';

Answer : C

Question 2

Refer to the exhibit.

A global sales organization operates in three regions: AMERICAS, EMEA: and APAC. Each region stores its sales transactions in a separate database in which the employees update customer data through a third-party app. The data is extracted into three QVDs.

A data architect sets up a two-tier architecture for the data load. The data architect needs to add the region to the data model.

Which technique should the data architect use to create the Region field?

ACreate a Region field in the SalesTransaction table and populate using fixed region values while loading from each source

BCreate a Region field in the Employee table and populate using the LTrim function on the EmployeelD

CCreate a Region field in the Employee table and populate using the SubField function on the EmployeelD

DCreate a Region field in the SalesTransaction table and create a mapping table based on the Country field in the Customer table

Answer : D

Question 3

A data architect needs to create an app to analyze 30-day re-admissions at a hospital.

* The medical record system does NOT calculate re-admission data

* The business rule to follow: if a patient is admitted to a hospital within 30 days after being discharged from a previous hospital stay, that event should be captured in the app with a flag called "30-day Re-admission"

* Data being used from the patient record includes hospital account ID, patient ID, admission dater and discharge date

Which action should the data architect perform first to meet these requirements?

ASequence patient records by hospital account ID and patient ID using the Peek function

BSequence patient records by patient ID using the Peek function

CCalculate the days since previous discharge using admission date and discharge date

DOrder patient records by patient ID and admission date

Answer : A

Question 4

Refer to the exhibit.

A shipping company needs to track its shipments using Qlik Sense A data architect has the data in Excel as shown on the left Business rules state that if the ShipmentDate field is empty, it should be populated with the first valid previous date as shown on the right. Which script should the data architect use to meet this requirement?

AOption A

BOption B

COption C

DOption D

Answer : A

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 : A

Question 6

A data architect needs to load Table_A from an Excel file and sort the data by Field_2.

Which script should the data architect use?

AOption A

BOption B

COption C

DOption D

Answer : C

Question 7

Refer to the exhibit.

A data architect needs to analyze the number of orders by customer. The data is stored in two Excel files: Orders and Customers The data architect creates a bar chart, but the data is obviously incorrect. What should the data architect do to resolve this issue?

AOpen the data manager, split the Customers table, and Concatenate Orders and Customers on the CustomerlD field

BOpen the data manager split the Customers table, and associate on CustomerlD

COpen the data load editor, use CONCATENATE to concatenate Orders and Customers

DOpen the data load editor, rename the CustomerlD field, and concatenate Orders and Customers

Answer : A

Qlik QSDA2019 Qlik Sense Data Architect Exam Practice Test