Summer Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ecus65

Qlik QSDA2021 - Qlik Sense Data Architect Certification Exam - February 2021 Release

Qlik QSDA2021 Premium Access     Download Demo    
Page: 2 / 2
Total 50 questions

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?

A.

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

B.

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

C.

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

D.

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

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)

A.

Option A

B.

Option B

C.

Option C

D.

Option D

Refer to the exhibit

A data architect develops an app for Coffee4all, a coffee company with stores located throughout Europe

The script runs successfully, but the Stores table does not have any values.

What should the data architect do?

A.

Use where exists (ID, StorelD)

B.

Use where exists (ID)

C.

Use Concatenate before loading the Stores table

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.

A circular reference with one table disconnected

B.

A synthetic table with two synthetic keys

C.

A synthetic table with three synthetic keys

D.

A synthetic table and one synthetic key

The Marketing department is using some similar KPIs in different apps that need to be modified frequently according to the business needs. The KPIs are created using master items with the same expression.

Which method should the data architect use to manage the modifications in all apps?

A.

Create a variable repository and load them using INCLUDE statements in the apps where needed

B.

Create a selection app with all the master items and use an on-demand app generation method.

C.

Create a core app with all the master items needed and use a BINARY load in the other apps.

D.

Create only a single app with all the master items needed and protect it with SECTION ACCESS.