SnowPro Core Certification — Question 1286

Which transformation techniques are supported for bulk loading data into Snowflake using the COPY INTO [table] command? (Choose two.)

Answer options

• A. Column grouping
• B. Column omission
• C. Column reordering
• D. Column aggregation
• E. Selection of a limited number of rows

Correct answer: B, C

Explanation

The correct answers are B and C because Snowflake allows for column omission and column reordering during the bulk load process using the COPY INTO command. Options A, D, and E are not supported as transformation techniques for this command.