Qlikview Discussions

Exam QSDA2024 All Questions

View all questions & answers for the QSDA2024 exam

Go to Exam

Exam QSDA2024 topic 1 question 2 discussion

Actual exam question from QlikView's QSDA2024

Question #: 2
Topic #: 1

[All QSDA2024 Questions]

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. 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;
B. 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;
C. 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;
D. 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);

Show Suggested Answer

Suggested Answer: A 🗳️

by amp6a8 at Nov. 4, 2024, 2:43 a.m.

Comments

Submit Cancel

amp6a8

2 weeks, 5 days ago

C is the correct answer. NoConcatenate is required to avoid the auto-concatenation of Temp and Table_A.

upvoted 1 times

...