QlikView QSDA2024 Exam Questions

Question 6 of 50

Refer to the exhibit.
Exam QSDA2024: Question 6 - Image 1

The salesperson ID and the office to which the salesperson belongs is stored for each transaction. The data model also contains the current office for the salesperson. The current office of the salesperson and the office the salesperson was in when the transaction occurred must be visible. The current source table view of the model is shown. A data architect must resolve the synthetic key.
How should the data architect proceed?

Comment out the Office in the Transaction table

Inner Join the Transaction table to the CurrentOffice table

Alias Office to CurrentOffice in the CurrentOffice table

Force concatenation between the tables

Correct Answer: C

Question 7 of 50

Refer to the exhibit.
Exam QSDA2024: Question 7 - Image 1

A data architect is loading two tables into a data model from a SQL database. These tables are related on key fields CustomerID and CustomerKey.
Which script should the data architect use?

OrderDetails:
LOAD OrderKey, CustomerKey AS CustomerID, LineTotal, ProductKey;
SQL SELECT * FROM OrderDetails;
Customers:
LOAD CustomerID, AccountNumber, CustomerName;
SQL SELECT * FROM Customers;

OrderDetails:
LOAD OrderKey, AUTONUMBER(CustomerKey), LineTotal, ProductKey;
SQL SELECT * FROM OrderDetails;
Customers:
LOAD AUTONUMBER (CustomerID) AS CustomerKey, AccountNumber, CustomerName;
SQL SELECT * FROM Customers;

OrderDetails:
LOAD OrderKey, CustomerKey, LineTotal, ProductKey;
SQL SELECT * FROM OrderDetails;
ALIAS CustomerKey AS CustomerID;
Customers:
LOAD CustomerID AS CustomerKey, AccountNumber, CustomerName;
SQL SELECT * FROM Customers;

OrderDetails:
LOAD OrderKey, CustomerKey, LineTotal, ProductKey;
SQL SELECT * FROM OrderDetails;
Customers:
LOAD CustomerID, AccountNumber, CustomerName;
RENAME FIELD CustomerKey TO CustomerID;

Correct Answer: A

Question 8 of 50

Refer to the exhibit.
Exam QSDA2024: Question 8 - Image 1

A data architect wants to transform the input data set to the output data set. Which prefix to the Qlik Sense LOAD command should the data architect use?

HierarchyBelongsTo

Peek

Generic

PivotTable

Correct Answer: C

Question 9 of 50

A data architect receives an error while running script.
What will happen to the existing data model?

The data model will be removed from the application.

The latest error-free data model will be maintained.

Newly loaded tables will be merged with the existing data model until the error is resolved.

The data model will be replaced with the tables that were successfully loaded before the error.

Correct Answer: B

Question 10 of 50

Refer to the exhibit.
Exam QSDA2024: Question 10 - Image 1

The Orders table contains a list of orders and associated details. A data architect needs to replace the SupplierID with the SupplierName using the second table as the source.
The output must be a single table.
Which script should the data architect use?

SuppliersMap:
MAPPING LOAD SupplierName, SupplierID;
SQL SELECT SupplierID, SupplierName FROM Suppliers;
LOAD *, APPLYMAP('SupplierName', SupplierID) AS SupplierName RESIDENT Orders;
DROP TABLE Orders;

LEFT JOIN(Products)
LOAD SupplierID,
SupplierName;
SQL SELECT SupplierID, SupplierName FROM Suppliers;

LEFT JOIN (Products)
LOAD DISTINCT SupplierID,
SupplierName;
SQL SELECT SupplierID, SupplierName FROM Suppliers;

SuppliersNames:
MAPPING LOAD ID, SupplierName as Name;
SQL SELECT SupplierID as ID, SupplierName FROM Suppliers;
LOAD *, APPLYMAP('SupplierNames', SupplierID) AS SupplierName RESIDENT Orders;
DROP TABLE Orders;

Correct Answer: D