Summer Sale 60% Special Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: best60

Qlik QSDA2022 Qlik Sense Data Architect Certification Exam - 2022 Exam Practice Test

Page: 1 / 8
Total 77 questions

Qlik Sense Data Architect Certification Exam - 2022 Questions and Answers

Testing Engine

  • Product Type: Testing Engine
$48  $119.99

PDF Study Guide

  • Product Type: PDF Study Guide
$42  $104.99
Question 1

Refer to the exhibit.

An existing app on Qlik Sense Enterprise is duplicated and transferred to a data architect to add some additional data When trying to manually reload the original script, the data architect receives an error

What should be done to make sure the script runs correctly?

Options:

A.

Add the line lib connect to 'QVD(abc_qservice/orderData.qvd) '; before the LOAD for the Order Data table

B.

Add the line lib connect to ' SQL (abc_qs9rvi.es) ‘ ;before the LOAD for the Order Detail table

C.

Give the data architect the Read rights on the data connections in the QMC

D.

Make the data architect the owner of the app in the QMC

Question 2

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 3

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?

Options:

A.

Binning

B.

Intersect

C.

AddressLookup

D.

Simplify

Question 4

Refer to the exhibits.

Some business users created an app by using the Add data functionality and loading two Excel files Orders and Customers.

The app is used to analyze the number of orders by customer. When the users create a bar chart to review the figures, the data shown is incorrect.

What should the data architect do to resolve this issue?

Options:

A.

Open the data manager, split the Customers table, and associate both tables on CustomerlD field

B.

Open the data manager, split the Customers table, and JOIN Orders and Customers on the CustomerlD field

C.

Open the data load editor and use JOIN instead of concatenate to combine Orders and Customers by CustomerlD

D.

Open the data load editor and apply a NOCONCATENATE function in the LOAD statement on the Orders table

Question 5

Refer to the exhibit.

A business department is forecasting revenue within an Excel spreadsheet.

A data architect needs to include this forecast into the existing data model, and without losing any data.

Which two sets of steps will meet these requirements? (Select two.)

Options:

A.

1. Load the Excel spreadsheet using the data load editor

2. Use the Unpivot function

3 Use the Sum function to group the forecast by date

4 Connect to the existing data model

B.

1. Load the Excel spreadsheet using the data load editor

2 Use the Crosstable function to unpivot the table

3 Create a composite key out of the date and region

4 Connect the new table to the data model

C.

1 Load the Excel spreadsheet using the data load editor

2. Change the sort order by date

3. Create a composite key out of the forecast and region 4 Connect to the existing data model

D.

1 Load the Excel spreadsheet into the data manager

2. Use the Unpivot function

3. Create a composite key from the date and region

4. Connect the new table to the data model

1 Load the Excel spreadsheet using the data manager

2 Rename the ForecastDate field to Date 3. Disable the Region

4 Connect to the existing data model

Question 6

Refer to the exhibits.

A music teacher needs to know which artists are eligible to enter this year's competition.

The teacher needs to find only the artists who have a music grade rank above two and play more than one instrument.

Which expression is needed for the Number of Instruments measure in the table?

Options:

A.

Count({$=2"}, Artist={"=Grade>2"}>}Instrument)

B.

Count({S=2"}, Grades={">2"}>}Instrument)

C.

Count({$=2"}, Artist={"=Grade>2"}>}Instrument)

D.

Count ({S=2M}, Grades={">2"}>}Instrument)

Question 7

A company has different departments. Executive and Sales should always be the first values in a Department filter pane. Which script must the data architect use to meet this requirement?

A)

B)

C)

D)

Options:

A.

Option A

B.

Option B

C.

Option C

D.

Option D

Question 8

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?

Options:

A.

Two

B.

Five

C.

Four

D.

Three

Question 9

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

Question 10

Refer to the exhibit.

What are the values of the variables vLoadStart and vLoadComplete after the script executes?

Options:

A.

vLoadStart; 'NOW{)'

vLoadComplete: current system date and time when the script ended

B.

vLoadStart: system date when the app was opened vLoadComplete 'now()'

C.

vLoadStart: system date when the app was opened vLoadComplete: current system date and time when the script ended

D.

vLoadStart: current system date and time when the script started vLoadComplete: 'now()'

Question 11

A data architect executes the following script:

What will Field_1 contain after this script is executed?

Options:

A.

Abed, abed, ABCD

B.

abcd

C.

Abcd, abcd

D.

Abed, abed, ABCD, ABCDABCD

Page: 1 / 8
Total 77 questions