Winter Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

Free and Premium Qlik QSDA2021 Dumps Questions Answers

Page: 1 / 2
Total 50 questions

Qlik Sense Data Architect Certification Exam - February 2021 Release Questions and Answers

Question 1

A data architect needs to revise an existing app.

The number of data rows has grown rapidly recently. While the app is in production, users are becoming increasingly unhappy about the response times when they make selections

Which two methods should be used to improve performance? (Select two.)

Options:

A.

Use dynamic script generation with variables

B.

Denormalize the schema

C.

Make sure any Ul variables are preceded by '='

D.

Use flags in the data model to simplify set analysis

E.

Create master items for all complex expressions

Buy Now
Question 2

Refer to the exhibit.

While performing a data load from the source shown, the data architect notices it is NOT appropriate for the required analysis.

The data architect runs the following script to resolve this issue:

Options:

A.

3

B.

1

C.

6

D.

4

Question 3

Refer to the exhibit.

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 script is valid to load the tables and maintain the correct association?

A)

B)

C)

D)

Options:

A.

Option A

B.

Option B

C.

Option C

D.

Option D

Question 4

Refer to the exhibit.

A data architect executes the script.

What will be the value of the first row for Field_1?

Options:

A.

A

B.

D

C.

Null

D.

4

Question 5

Adata 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?

Options:

A.

Use the data manager

B.

Load a calendar island

C.

Create a canonical calendar

D.

Create five master calendars

Question 6

A data architect needs to create an app that combines employee data from the Sales system and the Human Resources (HR) system.

These systems identify employees differently Employees in the HR system are identified with an alpha-numeric key Employees in the Sales system are identified using an integer key.

The Human Resources manager creates a table that maps these keys to another, called Associations.

The resultant data model must meet the following requirements:

• Associations must be valid

• The model must be optimized for performance

• The option must support multiple tables added

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

Options:

A.

APPLYMAP ( 'Associations , EmployeeKey ) as Employeekey;

B.

MAPSUBSTRING ( 'Associations' ,EMployeekey) As Employeekey;

C.

MAP EmloyeeKey USING Associations;

D.

RENAME FIELDS USING Associations;

Question 7

A data architect executes the following script:

What will be the result of Table A?

A)

B)

C)

D)

Options:

A.

Option A

B.

Option B

C.

Option C

D.

Option D

Page: 1 / 2
Total 50 questions