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);
A is not the correct answer, as tables with the same fields are concatenated automatically. Therefore, using NoConcatenate is mandatory -> C is the correct one.
C is the correct answer. NoConcatenate is required to avoid the auto-concatenation of Temp and Table_A.
upvoted 3 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
minikiu00
1 week, 3 days agoamp6a8
3 months ago