
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.
Which transformations are supported during bulk data loading with the COPY INTO command in Snowflake? (Choose two.)
A
Column grouping
B
Column omission
C
Column reordering
D
Column aggregation
E
Selection of a limited number of rows
No comments yet.