Qlik QSDA2019 Exam Questions Instant Access

Question 1

Refer to the exhibit.

A data architect builds a simple data model to show the relationship between students and exams. The data is loaded. Every StudentID in the Exams table should be found in the Students table. Some students have NOT taken an exam.

The data architect selects the field "StudentID" from the Students table and sees the following:

A data architect needs to fix this anomaly.

What should the data architect do to ensure data integrity?

AUpdate the Students table and add 16.7% of the missing records

BRemove records from the Exams table where StudentID is null

CUpdate the Exams table and add 33.4% of the missing records

DIn the LOAD script, add DISTINCT before the Students and Exams tables

Answer : C

Question 2

Refer to the exhibit.

A data architect is loading the tables and a synthetic key is generated.

How should the data architect resolve the synthetic key?

ACreate a composite key using OrderlD and LineNo

BRemove the LineNo field from Shipments and use the AutoNumber function on the OrderlD field

CRemove the LineNo field from both tables and use the AutoNumber function on the OrderlD field

DCreate a composite key using OrderlD and LineNo, and remove OrderlD and LineNo from Shipments

Answer : A

Question 3

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?

AApplyMap with two parameters after the Mapping load

BLeft Join between tables and Description.xlsx in every Department table

CEnter 'Missing description' in the blank rows for Description.xlsx, then use Mapping Load

DApplyMap with three parameters after the Mapping load

Answer : A

Question 4

A company decides to migrate all apps from QlikView to Qlik Sense. After converting an apps: there are several unconverted objects What should the data architect do?

ASave the unconverted objects as extensions and import them into Qlik Sense

BRemove the set analysis statements from the unconverted objects

CRe-create the unconverted objects

DSave the unconverted objects as master items

Answer : A

Question 5

A data architect needs to efficiently prepare a data model for a meeting in an hour.

The data source to be used contains five date fields. The app needs to display sales trends and compare the current year to date (CYTD) to last year to date (LYTD). The app is NOT going to be published. It will only be used for this meeting and a single user's ad-hoc analysis.

What should the data architect do to meet these requirements?

ACreate a canonical calendar

BLoad a calendar island

CUse the data manager

DCreate five master calendars

Answer : C

Question 6

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?

AOption A

BOption B

COption C

DOption D

Answer : D

Question 7

A data architect is loading two tables into a data model from a SQL database. These tables are related on key fields CustomerlD and CustomerKey. Which scripts should be used to load the data while maintaining the correct associations?

AOption A

BOption B

COption C

DOption D

Answer : A

Qlik Sense Data Architect QSDA2019 Exam Questions