QSDA2024 by Qlik Valid Free Exam Practice Test

Question 1

Sales managers need to see an overview of historical performance and highlight the current year's metrics.
The app has the following requirements:
* Display the current year's total sales
* Total sales displayed must respond to the user's selections
Which variables should a data architect create to meet these requirements?

A.

B.

C.

D.

Correct Answer: B

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 2

Refer to the exhibit.
A data architect needs to create a data model for a new app. Users must be able to see:
* Total sales for each customer
* Total sales for a given state
* Customers that have not had any sales
* Names of salesperson and regional account managers
* Total number of sales by date
Which steps should the data architect perform to meet these requirements?
Which steps should the data architect perform to meet these requirements?

A. 1. Load the Sales table
2. Load the Customers table
3. Load the Employees table twice; name it and alias the EmployeelD field appropriately each time B. 1. Load the Customers table and alias the CustID field as CustomerlD
2. Load the Employees table
3. Load the Sales table and alias the SalesPersonID and RegionalAcctMgrlD fields as EmployeelD C. 1. Use a Mapping Load for the Employees table
2. Load the Sales table and use ApplyMap to get the names for SalesPersonID and RegionalAcctMgrlD
3. Use a Left Join Load to add the customer details for the Sales table D. 1. Load the Customers table and alias the CustID field as CustomerlD
2. Use a Mapping Load for the Employees table
3. Load the Sales table and use ApplyMap to get the names for SalesPersonID and RegionalAcctMgrlD

Correct Answer: A

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 3

Refer to the exhibit.
A data architect needs to load data from Customers.qvd and sort the Country field in ascending order. Which method should be used?

A. Insert a Group By clause into the LOAD statement for the CustTemp table after the FROM clause B. Insert an Order By clause after the FROM clause in the CustTemp table C. Move the Country field to the first position in the field list in the LOAD statement D. Perform a Resident LOAD of the CustTemp table and insert an Order By clause in this table

Correct Answer: D

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 4

Exhibit.

One of the data sources a data architect must add for a newly developed app is an Excel spreadsheet. The Region field only has values for the first record for the region. The data architect must perform a transformation so that each row contains the correct Region.
Which function should the data architect implement to resolve this issue?

A. IntervalMatch B. Previous C. CrossTable D. Above

Correct Answer: B

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 5

Refer to the exhibit.

A data architect needs to build a dashboard that displays the aggregated sates for each sales representative. All aggregations on the data must be performed in the script.
Which script should the data architect use to meet these requirements?

A.

B.

C.

D.

Correct Answer: D

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 6

Exhibit.

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 they 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. Left join Orders and OrderDetails
5. Use Derive statement with the MasterCalendar table and apply the derive fields to OrderDate and ShipmentDate B. 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
5. Create a link table using the MasterCalendar table and create a concatenated field between OrderDate and ShipmentDate C. 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. 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 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

Correct Answer: B

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Qlik Sense Data Architect Certification Exam - 2024 - QSDA2024 Exam Practice Test