SnowPro Core Certification — Question 656

What operations can be performed while loading a simple CSV file into a Snowflake table using the COPY INTO command? (Choose two.)

Answer options

• A. Performing aggregate calculations
• B. Reordering the columns
• C. Grouping by operations
• D. Converting the datatypes
• E. Selecting the first few rows

Correct answer: B, D

Explanation

The correct answers are B and D because the COPY INTO command allows for reordering of columns and converting data types during the loading process. Options A and C are incorrect as aggregate calculations and grouping operations cannot be executed during the loading of data with this command, and option E is not relevant either, as selecting specific rows is not a function of the COPY INTO command.