Qlik Sense Business Analyst Certification (2024) — Question 1

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?

Answer options

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

Correct answer: A

Explanation

The correct answer, A, properly loads the data into a temporary table and sorts it before creating Table_A, ensuring that the sorting is applied correctly. Option B incorrectly attempts to sort data after loading it into Table_A, which does not achieve the desired outcome. Option C is similar to A but uses NoConcatenate, which is unnecessary for this case and could lead to confusion. Option D incorrectly attempts to sort the data for Table_A before it is loaded, which is not valid in this context.