Qlik QSDA2021 Qlik Sense Data Architect Certification Exam Practice Test

Page: 1 / 14
Total 50 questions
Question 1

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?

A)

B)

C)

D)



Answer : D

Question 2

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?



Answer : D

Question 3

A company generates 1 GB of ticketing data daily. The data is stored in multiple tables Business users need to see trends of tickets processed for the past. 2 years Users very rarely access the transaction-level data for a specific date. Only the past 2 years of data must be loaded which is 720 GB of data

Which method should a data architect use to meet these requirements?



Answer : A

Question 4

Refer to the exhibit.

Refer to the exhibit

A data architect develops an app for Coffee4all, a coffee company with stores located throughout Europe

The script runs successfully, but the Stores table does not have any values.

What should the data architect do?



Answer : B

Question 5

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?



Answer : D

Question 6

Refer to the exhibit.

A data architect is working with an app and creates some visualizations to check the dat

a. Some visualizations show issues in the data set.

* The Sales by Country table shows a total OrderValue of 18,300 sales while the KPI shows a total OrderValue of 20,600.

* The Sales monthly trend bar chart does not work with the Month field.

Which two data issues should the data architect fix in the app? (Select two.)



Answer : C, D

Question 7

A data architect needs to arrange data to create an app with a map where multiple location points consolidate into hexagonal areas based on postal codes

The areas will be color coded based on the number of vendors in the location.

Which GeoAnalytics operation should the data architect use?



Answer : A

Page:    1 / 14   
Total 50 questions