Qlik Sense Data Architect Certification Exam - 2024

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?

A data architect needs to load Table_A from an Excel file and sort the data by Field_2.
Which script should the data architect use?

A data architect needs to retrieve data from a REST API. The data architect needs to loop over a series of items that are being read using the REST connection.
What should the data architect do?

A table is generated resulting from the following script:
LOAD *,
Date(OrderTime) as Date;
LOAD * INLINE [

Order, OrderTime -
‘ABC’, 2022-03-12 10:20:15
‘XYZ’, 2022-03-12 11:21:15
‘DEF’, 2022-03-12 10:21:35];
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?

Refer to the exhibit.
What does the expression SUM([OrderNetAmount]) return when all values in LineNo are selected?