Weekend Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = simple70

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

Pass the Qlik Sense Data Architect QSDA2021 Questions and answers with ExamsMirror

Practice at least 50% of the questions to maximize your chances of passing.

Exam QSDA2021 Premium Access

View all detail and faqs for the QSDA2021 exam

Go to Exam

380 Students Passed

90% Average Score

98% Same Questions

Viewing page 1 out of 2 pages

Viewing questions 1-10 out of questions

Questions # 1:

Refer to the exhibits.

Question # 1

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:

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

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

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

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

Answer

Questions # 2:

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:

Binning

Intersect

AddressLookup

Simplify

Answer

Explanation

Binning is a GeoAnalytics operation that can be used to arrange data into hexagonal areas based on postal codes. The areas can then be color coded based on the number of vendors in the location.Source: Qlik

Binning is a GeoAnalytics operation that allows data points to be grouped into hexagonal areas based on a geographic field, such as postal codes. The data architect can use binning to group the location points by postal code and then color code the resulting hexagonal areas based on the number of vendors in each location.

This operation is useful for visualizing spatial data and identifying patterns or trends in the data.

Questions # 3:

Refer to the exhibit.

Question # 3

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:

Question # 3

Options:

Answer

Questions # 4:

Refer to the exhibit.

Question # 4

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?

Options:

A circular reference with one table disconnected

A synthetic table with two synthetic keys

A synthetic table with three synthetic keys

A synthetic table and one synthetic key

Answer

Questions # 5:

Refer to the exhibit.

Question # 5

A data architect is working on a Qlik Sense app the business has created to analyze the company orders and shipments. To understand the table structure, the business has given the following summary:

• Every order creates a unique orderlD and an order date in the Orders table

• An order can contain one or more order lines one for each product ID in the order details table

• Products in the order are shipped (shipment date) as soon as tliey are ready and can be shipped separately

• The dates need to be analyzed separately by Year Month, and Quarter

The data architect realizes the data model has issues that must be fixed.

Which steps should the data architect perform?

Options:

1. Create a key with OrderlD and ProductID in the OrderDetails table and in the Orders table

2. Delete the ShipmentID in the Shipments table

3. Delete the ProductID and OrderlD in the OrderDetails table

4. Concatenate Orders and OrderDetails

5. Create a link table using the MasterCalendar table and create a concatenated field between OrderDate and ShipmentDate

1. Create a key with OrderlD and ProductID in the OrderDeta Is table and in the Shipments table

2. Delete the ShipmentID in the Orders table

3. Delete the ProductID and OrderlD in the Shipmi

4. Left join Orders and OrderDetails

5. Use Derive statement with the MasterCalendar table and apply the derive fields to OrderDate and ShipmentDate

1. Create a key with OrderlD and ProductID in the OrderDetails tab e and in the Orders table

2. Delete the ShipmentID in the Shipments table

3. Delete the ProductID and OrderlD in the OrderDetails

4. Left join Orders and OrderDetails

5. Use Derive statement with the MasterCalendar table and apply the derive fields to OrderDate and ShipmentDate

1. Create a key with OrderlD and ProductID in the OrderDetails table and in the Shipments table

2. Delete the ShipmentID in the Orders table

3 Delete the ProductID and OrderlD in the Shipments table

4. Concatenate Orders and OrderDetails

Answer

Questions # 6:

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?

Options:

Section access and set analysis

QMC security rules and section access

QMC security rules and custom properties

Section access and sheet properties

Answer

Questions # 7:

A data architect is building a model to show trends in visualizations across seven date fields. The seven date fields reside in different tables. The data architect must efficiently build this data model.

Requirements:

• A single date selector

• Show all dates, even those with NO activity

• Minimize the impact on server resources and p

Which two solutions should the data architect use? (Select two.)

Options:

Canonical calendar

Generic load

Data island

Multiple calendars

Link table

Answer

A, E

Explanation

A canonical calendar should be used to create a single date selector that can be used to show all dates, even those with no activity. A link table should be used to join the seven date fields from different tables, which will minimize the impact on server resources and performance.Source: Qlik

Questions # 8:

Refer to the exhibit.

Question # 8

A data architect executes the script.

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

Options:

Null

Answer

Questions # 9:

Question # 9

Refer to the exhibits.

The first table, Mastersports, contains the master list of all sport names that need to be loaded into the app. The second table, TeamMembers, contains the teams and team members registered for specific sports.

In a Qlik Sense app, a data architect is loading the two tables that need to be linked together based on the Sport field. The table format cannot be changed in the source.

What should the data architect do in the data load editor?

Options:

Apply a preceding LOAD from the TeamMembers table with the SUBFIELD function and rename the field to Sport

Apply a preceding LOAD to the MasterSports table with the SUBFIELD function to create the Sport field

Apply a FOR loop to load to the MasterSports table creating the values for the Sport field

Answer

Questions # 10:

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?