Exit QSDA2024 Qlik Sense Data Architect Certification - 2024
Question 2 of 5
0% complete
Q2 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 Next