Examice

Exam SnowPro Core All QuestionsBrowse all questions from this exam

Go to Exam

Question 1008

When unloading data with the COPY INTO command, what is the purpose of the PARTITION BY parameter option?

To sort the contents of the output file by the specified expression.

To delimit the records in the output file using the specified expression.

To include a new column in the output using the specified window function expression.

To split the output into multiple files, one for each distinct value of the specified expression.

Correct Answer: D

The purpose of the PARTITION BY <expression> parameter option in the COPY INTO <location> command is to split the output into multiple files, one for each distinct value of the specified expression.

Discussion

aws_godOption: D

https://docs.snowflake.com/en/sql-reference/sql/copy-into-location#optional-parameters

GwoOption: D

D is correct. https://docs.snowflake.com/en/user-guide/data-unload-overview