QlikView QSDA2024 - Qlik Sense Data Architect Certification Exam - 2024 Exam
Page: 2 / 10
Total 50 questions
Question #6 (Topic: Exam A)
Refer to the exhibit.
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?
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?
A. Comment out the Office in the Transaction table
B. Inner Join the Transaction table to the CurrentOffice table
C. Alias Office to CurrentOffice in the CurrentOffice table
D. Force concatenation between the tables
Answer: C
Question #7 (Topic: Exam A)
Refer to the exhibit.
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?
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?
A. OrderDetails:
LOAD OrderKey, CustomerKey AS CustomerID, LineTotal, ProductKey;
SQL SELECT * FROM OrderDetails;
Customers:
LOAD CustomerID, AccountNumber, CustomerName;
SQL SELECT * FROM Customers; B. OrderDetails:
LOAD OrderKey, AUTONUMBER(CustomerKey), LineTotal, ProductKey;
SQL SELECT * FROM OrderDetails;
Customers:
LOAD AUTONUMBER (CustomerID) AS CustomerKey, AccountNumber, CustomerName;
SQL SELECT * FROM Customers; C. 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; D. OrderDetails:
LOAD OrderKey, CustomerKey, LineTotal, ProductKey;
SQL SELECT * FROM OrderDetails;
Customers:
LOAD CustomerID, AccountNumber, CustomerName;
RENAME FIELD CustomerKey TO CustomerID;
LOAD OrderKey, CustomerKey AS CustomerID, LineTotal, ProductKey;
SQL SELECT * FROM OrderDetails;
Customers:
LOAD CustomerID, AccountNumber, CustomerName;
SQL SELECT * FROM Customers; B. OrderDetails:
LOAD OrderKey, AUTONUMBER(CustomerKey), LineTotal, ProductKey;
SQL SELECT * FROM OrderDetails;
Customers:
LOAD AUTONUMBER (CustomerID) AS CustomerKey, AccountNumber, CustomerName;
SQL SELECT * FROM Customers; C. 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; D. OrderDetails:
LOAD OrderKey, CustomerKey, LineTotal, ProductKey;
SQL SELECT * FROM OrderDetails;
Customers:
LOAD CustomerID, AccountNumber, CustomerName;
RENAME FIELD CustomerKey TO CustomerID;
Answer: A
Question #8 (Topic: Exam A)
Refer to the exhibit.
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?
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?
A. HierarchyBelongsTo
B. Peek
C. Generic
D. PivotTable
Answer: C
Question #9 (Topic: Exam A)
A data architect receives an error while running script.
What will happen to the existing data model?
What will happen to the existing data model?
A. The data model will be removed from the application.
B. The latest error-free data model will be maintained.
C. Newly loaded tables will be merged with the existing data model until the error is resolved.
D. The data model will be replaced with the tables that were successfully loaded before the error.
Answer: B
Question #10 (Topic: Exam A)
Refer to the exhibit.
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?
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?
A. SuppliersMap:
MAPPING LOAD SupplierName, SupplierID;
SQL SELECT SupplierID, SupplierName FROM Suppliers;
LOAD *, APPLYMAP('SupplierName', SupplierID) AS SupplierName RESIDENT Orders;
DROP TABLE Orders; B. LEFT JOIN(Products)
LOAD SupplierID,
SupplierName;
SQL SELECT SupplierID, SupplierName FROM Suppliers; C. LEFT JOIN (Products)
LOAD DISTINCT SupplierID,
SupplierName;
SQL SELECT SupplierID, SupplierName FROM Suppliers; D. 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;
MAPPING LOAD SupplierName, SupplierID;
SQL SELECT SupplierID, SupplierName FROM Suppliers;
LOAD *, APPLYMAP('SupplierName', SupplierID) AS SupplierName RESIDENT Orders;
DROP TABLE Orders; B. LEFT JOIN(Products)
LOAD SupplierID,
SupplierName;
SQL SELECT SupplierID, SupplierName FROM Suppliers; C. LEFT JOIN (Products)
LOAD DISTINCT SupplierID,
SupplierName;
SQL SELECT SupplierID, SupplierName FROM Suppliers; D. 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;
Answer: D
