COF-C02 · Question #375
What transformations are supported when loading data into a table using the COPY INTO <table> command? (Select TWO).
The correct answer is A. Column reordering B. Column omission. The COPY INTO <table> command supports a limited set of transformations via an inline SELECT statement within the COPY command. Specifically, column reordering (selecting columns in a different order than the file) and column omission (excluding certain columns from the load)…
Question
What transformations are supported when loading data into a table using the COPY INTO <table> command? (Select TWO).
Options
- AColumn reordering
- BColumn omission
- CJOIN function
- DFLATTEN function
- EGROUP BY function
How the community answered
(24 responses)- A88% (21)
- C8% (2)
- E4% (1)
Explanation
The COPY INTO <table> command supports a limited set of transformations via an inline SELECT statement within the COPY command. Specifically, column reordering (selecting columns in a different order than the file) and column omission (excluding certain columns from the load) are supported. JOINs, GROUP BY, and aggregation functions are not supported within COPY INTO. FLATTEN can be used for semi-structured data but is not one of the two primary transformation types highlighted in this exam objective.
Topics
Community Discussion
No community discussion yet for this question.