SnowPro Core Certification — Question 792

How does the PARTITION BY option affect an expression for a COPY INTO [location] command?

Answer options

• A. The unload operation partitions table rows into separate files unloaded to the specified table.
• B. The unload operation partitions table rows into separate files unloaded to the specified stage.
• C. A single file will be loaded with a user-defined partition key and the user can use this partition key for clustering.
• D. A single file will be loaded with a Snowflake-defined partition key and Snowflake will use this key for pruning.

Correct answer: B

Explanation

Option B is correct because the PARTITION BY option organizes the data into separate files that are unloaded to a specified stage, which is essential for managing data efficiently. Options A, C, and D are incorrect as they either misrepresent the destination of the unload operation or incorrectly describe how partitioning and keys operate in this context.