
Explanation:
The correct answers are A (Column reordering) and B (Column omission) because the COPY INTO command supports these transformations when loading data into a table. According to Snowflake documentation and the community discussion with 100% consensus, COPY INTO allows for column reordering and omission through the use of a SELECT statement in the transformation. Options C (JOIN function), D (FLATTEN function), and E (GROUP BY function) are not supported transformations within the COPY INTO command itself, as these are more complex operations typically performed after data loading or through separate SQL transformations.
Ultimate access to all questions.
No comments yet.