SnowPro Core Certification — Question 1030

What transformations are supported when loading data into a table using the COPY INTO [table] command? (Choose two.)

Answer options

• A. Column reordering
• B. Column omission
• C. JOIN function
• D. FLATTEN function
• E. GROUP BY function

Correct answer: A, B

Explanation

The correct answers, A and B, indicate that you can rearrange columns and exclude certain columns when loading data into a table using the COPY INTO command. The other options, C, D, and E, involve operations that are not supported in this context for data loading.