Exam SnowPro Core All QuestionsBrowse all questions from this exam
Question 352

When loading data into Snowflake, the COPY command supports which of the following?

    Correct Answer: C

    When loading data into Snowflake using the COPY command, it indeed supports column reordering. This functionality allows users to load data into tables where the desired column order in the file does not match the order in the table, by specifying the columns in a list. This helps in ensuring that the data is correctly mapped to the table schema despite differences in column ordering.

Discussion
SnowProCertDec22Option: C

https://docs.snowflake.com/en/user-guide/data-load-transform.html#reorder-csv-columns-during-a-load

MultiCloudIronManOption: C

Verified