Qlik Sense Data Architect Certification Exam - 2024

Here you have the best QlikView QSDA2024 practice exam questions

You have 50 total questions across 10 pages (5 per page)
These questions were last updated on February 17, 2026
This site is not affiliated with or endorsed by QlikView.

Question 1 of 50

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

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?

1. Use a Mapping Load for the Employees table
2. Load the Sales table and use ApplyMap to get the names for SalesPersonID and RegionalAcctMgrID
3. Use a Left Join Load to add the customer details for the Sales table

1. Load the Customers table and alias the CustID field as CustomerID
2. Use a Mapping Load for the Employees table
3. Load the Sales table and use ApplyMap to get the names for SalesPersonID and RegionalAcctMgrID

1. Load the Sales table
2. Load the Customers table
3. Load the Employees table twice; name it and alias the EmployeeID field appropriately each time

1. Load the Customers table and alias the CustID field as CustomerID
2. Load the Employees table
3. Load the Sales table and alias the SalesPersonID and RegionalAcctMgrID fields as EmployeeID

Question 2 of 50

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?

Temp:

LOAD -
Field_1,
Field_2,

Field_3 -
FROM [lib://Data/Table_A.xlsx]
(ooxml, embedded labels, table is Sheet1);
Table_A:
LOAD *
resident Temp Order by Field_2 asc;
drop Table Temp;

Table_A:

LOAD -
Field_1,
Field_2,

Field_3 -
FROM [lib://Data/Table_A.xlsx]
(ooxml, embedded labels, table is Sheet1);
Order by Field_2 asc;

Temp:

LOAD -
Field_1,
Field_2,

Field_3 -
FROM [lib://Data/Table_A.xlsx]
(ooxml, embedded labels, table is Sheet1);

NoConcatenate -
Table_A:
LOAD *
resident Temp Order by Field_2 asc;
drop Table Temp;

Table_A:
LOAD *
Order by Field_2 asc;

LOAD -
Field_1,
Field_2,

Field_3 -
FROM [lib://Data/Table_A.xlsx]
(ooxml, embedded labels, table is Sheet1);

Question 3 of 50

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?

Recreate the SQL Statement with the correct parameters

Use the REST Connector with pagination mechanism

Use pagination of the REST Connector to create a template of the desired data

Use With Connection to pass a parameter to the REST URL

Question 4 of 50

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?

LOAD *,
Floor(MakeDate(OrderTime,'YYYY-MM-DD')) 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];

LOAD *,
Date(OrderTime,'YYYY-MM-DD') 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];

LOAD *,
Date#(OrderTime,'YYYY-MM-DD') 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];

LOAD *,
Date(Floor(OrderTime),'YYYY-MM-DD') 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];

Question 5 of 50

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

1590

1490

690

1810

About the QlikView QSDA2024 Certification Exam

About the Exam

The QlikView QSDA2024 (Qlik Sense Data Architect Certification Exam - 2024) validates your knowledge and skills. Passing demonstrates proficiency and can boost your career prospects in the field.

How to Prepare

Work through all 50 practice questions across 10 pages. Focus on understanding the reasoning behind each answer rather than memorizing responses to be ready for any variation on the real exam.

Why Practice Exams?

Practice exams help you familiarize yourself with the question format, manage your time, and reduce anxiety on the test day. Our QSDA2024 questions are regularly updated to reflect the latest exam objectives.