Offering Free access to Qlik Sense Data Architect QSDA2021 Exam Questions Pool Bank

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

Testing Engine

Product Type: Testing Engine

$42 ~~$119.99~~

Add to Cart

PDF + Testing Engine

Product Type: PDF + Testing Engine

$59.5 ~~$169.99~~

Add to Cart

PDF Study Guide

Product Type: PDF Study Guide

$36.75 ~~$104.99~~

Add to Cart

Question 1

A data architect is creating an app using three tables. After executing the script, a warning displays

Which two steps should the data architect do to resolve this warning? (Select two.)

Options:

Remove the rename statement (line 24) in the ProductPriceList table leaving the Product field name as is.

Rename the Category field in the ProductPriceLis table to PnceCategory (line 24).

Move the preceding Load statement in line 10 between table name (line 23) and Load statement (line 24).

insert "Join (ProductDetails)" in front of the Load statement in line 24 to combine ProductPriceList with ProductDetails

Question 2

Refer to the exhibits.

An app is built to analyze salesperson performance by department. Departments are unique within the Departments table, but Salespeople often move between departments. A strict business rule states that a salesperson must be associated with ONLY one department at all times.

The data architect creates a summary of department performance and notices the values are incorrect. The total sales KPI shows the correct result.

How should the data architect modify the data model to correct this issue?

Options:

Create a bridge table between the Departments and Salespeople tables to resolve the many-to-many relationship

Create a bridge table between the Transactions and Salespeople tables to resolve the many-to-many relationship

Join the Departments and Salespeople tables to resolve the many-to-many relationship

Join the Transactions and Salespeople tables to resolve the many-to-many relationship

Question 3

ITALY IT001 HR

GERMANY DE002 HR

SPAIN SP03 FINANCE

FRANCE FRO04 SALES

Refer to the exhibit

A company stores the employee data within a key composed of Country UserlD, and Department. These fields are separated by a blank space. The UserlD field is composed of two characters that indicate the country followed by a unique code of two or three digits. A data architect wants to retrieve only that unique code.

Options:

LTRIM (SUBFIELD (Key, ' ', 2), 2)

MID ( SUBFIELD (Key , ' ', 2), 3)

RIGHT(SUBFIELD (Key,' ', 2), 3)

LEFT(SUBFIELD(Key, ' ', 2), 2)

Question 4

Refer to the exhibit.

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

Question 5

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

Question 6

A data architect wants to combine data on presentand historic sales performance.The historic data is stored in a de-normalized archive, and the present data is maintained in a database. The output must be contained in a single table.

Which script should the data architect use?