SnowPro Core Recertification — Question 50

When unloading data with the COPY INTO <location> command, what is the purpose of the PARTITION BY <expression> parameter 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 <expression> option allows for the output to be divided into multiple files based on distinct values of the specified expression. Options A, B, and C describe different functionalities that do not pertain to partitioning the output into separate files.