New Year Sale - Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70dumps

QSDA2022 Questions and Answers

Question # 6

A data architect wants to combine data on present and 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?

A)

B)

C)

D)

A.

Option A

B.

Option B

C.

Option C

D.

Option D

Full Access
Question # 7

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

Full Access
Question # 8

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)

A.

Option

B.

Option

C.

Option

D.

Option

Full Access
Question # 9

A data architect needs to develop multiple apps for various departments. More departments are requesting apps over time The company uses specific requirements for the number interpretation variables (e.g., ThousandSep, DecimalSep) found at the beginning of a LOAD script.

The data architect wants to reduce duplicate scripts but does not want to copy and paste the number interpretation variables each time new app is created. The data architect prefers to use the least amount of script in Qlik Sense.

How should the data architect meet these requirements?

A.

Save the script for the number interpretation variables in a text file and use the CALL function to insert the variables.

B.

Create an Excel file with the number interpretation variables and use a FOR Next loop to load the variables into Qlik Sense

C.

Save the script for the number interpretation variables in a text file and INLUDE function to insert the variables

D.

Create an Excel file with the number interpretation variables and apply the variables to the app using a mapping table

Full Access
Question # 10

A data architect plans to build an app that contains geographically diverse data that must be specific to user run-time selections. The source contains transactional data. The app must have minimal impact on already limited server resources.

Which approach should the data architect use?

A.

Loop and Reduce

B.

QVDs

C.

In-memory

D.

ODAG

Full Access
Question # 11

A data architect completes development of a new app with two data sources Both data sources will also be used by other apps in the future The sources have different data refresh frequencies

• Source 1 Contains frequently updated data and must be refreshed hourly

• Source 2 Contains data that is transferred from a partner and must be refreshed weekly

Tasks must be created to load the data sources and make sure that the new app uses the most current data The data will be stored in two QVDs Which tasks should be created to meet these requirements'?

A.

1 Schedule Task 1 to run hourly and refresh data from Source 1

2 Schedule Task 2 to run weekly and refresh data from Source 2

3. Schedule a task for the app that is dependent on completion of Tasks 1 or 2 that loads the two QVDs

B.

1. Schedule Task 1 to run hourly and refresh data from Source 1

2 Schedule Task 2 that is dependent on Task 1 to refresh data from Source 2

3. Schedule a task for the app that is dependent on completion of Task 2 that loads the two QVDs

C.

1. Schedule Task 1 to run hourly and refresh data from Source 1

2 Schedule Task 2 that is dependent on Task 1 to refresh data from Source 2

3 Schedule a task for the app that is dependent on completion of Tasks 1 and 2 that loads the two QVDs

D.

1 Schedule Task 1 to run hourly and refresh data from Source 1

2 Schedule Task 2 to run weekly and refresh data from Source 2

3. Schedule a task for the app that is dependent on completion of Task 2 that loads the two QVDs

Full Access