Free QSDA2024 Web TestEngine Demo | VCEDump

Exit VCEDump QSDA2024 Qlik Sense Data Architect Certification - 2024

Q8 Single choice

A data architect needs to load Table_A from an Excel file and sort the data by Reld_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);

Previous Check answer

Question map8 / 8

1 2 3 4 5 6 7 8

Current Correct Answered Incorrectly Reviewed 0 Remaining 8

Marked Questions0

No marked questions.

Answered Incorrectly0

No incorrect answers.