SnowPro Core Certification — Question 967

When unloading data with the COPY INTO [location] command, what is the purpose of the PARTITION BYparameter option?

Answer options

• A. To sort the contents of the output file by the specified expression.
• B. To delimit the records in the output file using the specified expression.
• C. To include a new column in the output using the specified window function expression.
• D. To split the output into multiple files, one for each distinct value of the specified expression.

Correct answer: D

Explanation

The correct answer is D because the PARTITION BY option is designed to create separate output files for each distinct value of the specified expression, which helps in organizing the data. Option A is incorrect as it refers to sorting rather than partitioning. Option B is wrong because delimiting records does not pertain to the purpose of PARTITION BY. Option C is also incorrect since it talks about adding columns rather than splitting output files.