Qlik Sense Data Architect Certification Exam - 2024

Here you have the best QlikView QSDA2024 practice exam questions

You have 17 total questions to study from
Each page has 5 questions, making a total of 4 pages
You can navigate through the pages using the buttons at the bottom
This questions were last updated on October 30, 2025
This site is not affiliated with or endorsed by QlikView.

Question 1 of 17

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);

Correct Answer: A

Question 2 of 17

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

Correct Answer: B

Question 3 of 17

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

1590

1490

690

1810

Correct Answer: A

Question 4 of 17

A data architect needs to write the expression for a measure on a KPI to show the sales person with the highest sales. The sort order of the values of the fields is unknown. When two or more sales people have sold the same amount, the expression should return all of those sales people.
Which expression should the data architect use?

Concat(DISTINCT IF(Aggr(Rank(Sum(Sales),4),SalesPerson)=1,SalesPerson),' ')

FirstSortedValue(DISTINCT SalesPerson,-Aggr(Sum(Sales),SalesPerson))

FirstSortedValue(SalesPerson,-Aggr(Sum(Sales),SalesPerson))

Concat(DISTINCT IF(Aggr(Rank(Sum(Sales),1),SalesPerson)=1,SalesPerson),' ')

Correct Answer: D

Question 5 of 17

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

A data architect must load the two tables without creating a synthetic key. The data architect also must make sure expressions like Sum([Budgeted Sales]) are calculated correctly.
Which load script meets these requirements?

Correct Answer: D