Qlik Sense Data Architect Certification Exam - June 2018 Release (QSDA2018) Free Practice Test

Question 1

Sales managers need to see an overview of historical performance and highlight the current year's metrics App requirements:
* Display the current year's total sales
* Total sales displayed must respond to the user's selections
Which variables should a data architect create to meet these requirements?
A)

B)

C)

D)

A. Option D

B. Option C

C. Option A

D. Option B

Correct Answer: C

Question 2

Refer to the exhibit.

A global company recently released an app that uses much more memory than similar apps have used When reviewing data in the data manager, the data architect observes that several fields use Globally Unique Identifiers (GUIDs). There is one key field. Other fields are used for different KPIs to count the number records. The data architect must reduce the memory used as much as possible. Which steps should a data architect take to meet these requirements?

A. 1 Use the AutoNumber function to convert the linking GUIDs to numbers
2 Replace the non-key GUID fields with a flag, and use them to get a unique count for KPIs

B. 1 Replace the non-key field GUIDs with RowNoQ to maintain a field that can be used to get a unique count 2. Split the linking GUID fields into five sections using the SubField function to reduce the uniqueness

C. 1 Use the AutoNumber function to convert the linking GUIDs to numbers
2. Use Indexing for non-key GUID fields to create an Index field and use to get a unique count for KPIs

D. 1. Use the IterNoQ function to convert the linking GUIDs to numbers
2 Replace the non-linking GUID fields with RowNo() to create an Index field and use to get a unique count for KPI

Correct Answer: D

Question 3

Refer to the exhibit.
A data architect needs to build a sales dashboard. Data is stored in a legacy database. The extracted data contains the date in the format, 'YYYYDDMM' Due to the source date format, the dates are being loaded as numbers.
Which function should the data architect use to fix this issue?

A. Timestamp

B. Timestamp#

C. Date

D. Date#

Correct Answer: D

Question 4

Refer to the exhibits

Which corrective action should be taken to achieve the expected view?

A. Use distinct in the LOAD statement.

B. Add a link table.

C. Use upper () to align the Salesperson fields

D. Alias one of the fields in the Orders table.

Correct Answer: D

Question 5

Refer to the exhibit.

Which values of the REGION field will be visible for User C when the user opens the app?

A. NORTH, EAST, WEST, and SOUTH

B. EAST and WEST

C. NORTH, EAST and WEST

D. EAST, WEST and SOUTH

Correct Answer: A

Welcome to TestSimulate

Qlik Sense Data Architect Certification Exam - June 2018 Release (QSDA2018) Free Practice Test