QSDA2022 Online Practice Questions and Answers

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 generates 1 GB of ticketing data daily. The data is stored in multiple tables Business users need to see trends of tickets processed for the past. 2 years Users very rarely access the transaction-level data for a specific date. Only the past 2 years of data must be loaded which is 720 GB of data

Which method should a data architect use to meet these requirements?

A. Load only aggregated data for 2 years and use On-Demand App Generation (ODAG) for transaction data

B. Load only aggregated data for 2 years and apply filters on a sheet for transaction data

C. Load only 2 years of data in an aggregated app and create a separate transaction app for occasional use

D. Load only 2 years of data and use best practices in scripting and visualization to calculate and display aggregated data

Refer to the exhibit.

What are the values of the variables vLoadStart and vLoadComplete after the script executes?

A. vLoadStart; 'NOW{)' vLoadComplete: current system date and time when the script ended

B. vLoadStart: system date when the app was opened vLoadComplete 'now()'

C. vLoadStart: system date when the app was opened vLoadComplete: current system date and time when the script ended

D. vLoadStart: current system date and time when the script started vLoadComplete: 'now()'

Refer to the exhibit.

A data architect is loading two tables: Orders and Product. The Product table includes attributes and values for each ProductID such as Colour, Price, Category, and Description.

The business analyst can filter by the value of these attributes. For performance reasons, the Data Model will use two tables.

Which solution should the data architect apply in the Data Load Editor to build the ProductDetails table?

For performance reasons, the Data Model will use two tables a Load Editor to build the ProductDetails table?

A. Use a For loop to concatenate all of the Products table and apply a Generic Load to the final concatenate table

B. Use a For loop to apply a Generic load to the Product table and concatenate the generic tables together

C. Use a Generic Load in the Product table and a For loop to left join each Generic table

A table is generated resulting from the following script

When the data architect selects a date, some, but NOT all, orders for that date are shown How should the data architect modify the script to show all orders for the selected date? A)

B)

C)

D)

A. Option A

B. Option B

C. Option C

D. Option D

Refer to the exhibit.

A data architect builds a simple data model to show the relationship between students and exams. The data is loaded. Every StudentID in the Exams table should be found in the Students table. Some students have NOT taken an exam. The data architect selects the field "StudentID" from the Students table and sees the following:

A data architect needs to fix this anomaly.

What should the data architect do to ensure data integrity?

A. Update the Students table and add 16.7% of the missing records

B. Remove records from the Exams table where StudentID is null

C. Update the Exams table and add 33.4% of the missing records

D. In the LOAD script, add DISTINCT before the Students and Exams tables

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?

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

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

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

A data architect needs to upload data from ten different sources, but only if there are any changes after the last reload When data is updated, a new file is placed into a folder mapped to E A439926003 The data connection points to this folder.

The data architect plans a script which will:

1.

Verify that the file exists

2.

If the file exists, upload it Otherwise, skip to the next piece of code

The script will repeat this subroutine for each source. When the script ends, all uploaded files will be removed with a batch procedure.

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

A. FileSize, IF, THEN, END IF

B. FilePath, IF, THEN. Drop

C. FileExists, FOR EACH, IF

D. FilePath, FOR EACH, Peek, Drop

Refer to the exhibit.

A data architect loads sales data and creates a table which shows only customers who made purchases in 2018 and 2019. The data architect applies the following set analysis expression on the sales measure. Count<{})>} Customer ID)

Which option shows the resulting table after the expression is applied?

A. Option A

B. Option B

C. Option C

D. Option D

A data architect is loading two tables into a data model from a SQL database. These tables are related on key fields CustomerlD and CustomerKey. Which script is valid to load the tables and maintain the correct association?

A. Option A

B. Option B

C. Option C

D. Option D