
Explanation:
The COPY INTO command in Snowflake supports column reordering (C) and column omission (B) during bulk data loading. Column reordering allows mapping source columns to target table columns in a different order, while column omission enables loading only specific columns from the source file. Column grouping (A) is not a supported transformation - Snowflake requires each column to be specified individually. Column aggregation (D) is not supported during COPY operations as aggregation requires SQL processing. Selection of a limited number of rows (E) is achieved through file filtering or staging transformations, not directly through COPY INTO transformations. The community discussion shows 100% consensus on BC as the correct answer, confirming these are the only two transformation techniques supported during bulk loading with COPY INTO.
Ultimate access to all questions.
No comments yet.