QSDA2022 Qlik Sense Data Architect Certification Exam - 2022 Questions and Answers

A data architect needs to upload data from ten different sources, but only if there are any changes after the last reload When data is updated, a new file is placed into a folder mapped to E A439926003 The data connection points to this folder.

The data architect plans a script which will:

1. Verify that the file exists

2. If the file exists, upload it Otherwise, skip to the next piece of code

The script will repeat this subroutine for each source. When the script ends, all uploaded files will be removed with a batch procedure.

Which option should the data architect use to meet these requirements?

Refer to the exhibit.

A data architect loads sales data and creates a table which shows only customers who made purchases in 2018 and 2019. The data architect applies the following set analysis expression on the sales measure. Count<{})>} Customer ID)

Which option shows the resulting table after the expression is applied?

A)

B)

C)

D)

Refer to the exhibit.

A data architect must classify each product into a price group. The price groups must be the same width by default and allow users to dynamically change the width of the bucket during analysis.

Which feature should the data architect use to meet these requirements?

A data architect needs to develop a script to export tables from a model based upon rules from an independent file. The structure of the text file with the export rules is as follows:

These rules govern which table in the model to export, what the target root filename should be, and the number of copies to export.

The TableToExport values are already verified to exist in the model.

In addition, the format will always be QVD, and the copies will be incrementally numbered.

For example, the Customer table would be exported as:

What is the minimum set of scripting strategies the data architect must use?

Refer to the exhibit.

A customer needs to load forecast data from an Excel file.

Which preceding load statement should the data architect use to load the data?

A)

B)

C)

D)

Multiple department fields in a dataset require a description

A data architect needs to add the department descriptions or a default value when the department does NOT have a description

Which strategy should the data architect use to meet these requirements?

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?

A data architect needs to load data from two different databases Additional data will be added from a folder that contains QVDs. text files, and Excel files.

What is the minimum number of data connections required?