Answer: Column reordering, Column omission

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.

Author: LeetQuiz Editorial Team