Free Qlik QSDA2021 Practice Exam with Questions & Answers

Refer to the exhibit.

A data architect needs to add a Budget table to the current Qlik Sense app. A Budget table with the fields Budget, CustomerlD, and ProductlD is loaded into the model. What will be created?

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?

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

A)

B)

C)

D)

Refer to the exhibit.

A data architect must classify each product into a price group. The price groups must be the same width by default and allow users to dynamically change the width of the bucket during analysis.

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

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?

A data architect needs to add the UnitCost field from the ProductCost table in the Dim_Products Table.

Which script code should the data architect use?

A)

B)

C)

D)

Refer io the exhibit.

A data architect needs to modify the script to ONLY load rows from Table_B when Field_1 and Field_2 are the same as in Table_A. (For example, only the row containing A, 1, 456 should be loaded from Table_B.)

Which script should the data architect use?

A)

B)

C)

D)

A company has a stream with multiple apps One of the apps is a multi-regional sales app.

A data architect must set up security for users to access the stream, enter the app, and view specific sheets and data.

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

A data architect needs to write the expression for a measure on a KPI to show the sales person with the highest sales The sort order of the values of the fields is unknown When two or more sales people have sold the same amount, the expression should return all of those sales people

Which expression should the data architect use?

A data architect needs to build an Order Fulfillment app. The business requires front-end performance is optimized.

The OrderDate and ShipmentDate are located in different tables.

The user needs to identify the data type and must be able to:

• Show trends for orders and shipments

• Use a single filter for both date fields

• Analyze data over fiscal periods

Which steps should the data architect take to build the data model?