SnowPro Core Certification — Question 1221

When unloading Snowflake relational data to a Parquet file format, why should the PARTITION BY clause be used?

Answer options

• A. It will provide a mechanism to encrypt each micro-partition with a unique key.
• B. It will guarantee data integrity by splitting the data into smaller, manageable chunks.
• C. It will increase storage efficiency by automatically compressing data based on access patterns.
• D. It will optimize query performance by filtering relevant partitions without scanning the entire dataset.

Correct answer: D

Explanation

The correct answer is D because using the PARTITION BY clause helps in improving query performance by allowing the system to filter out unnecessary partitions, thus reducing the amount of data scanned. Options A, B, and C do not accurately describe the benefits of using PARTITION BY in the context of exporting data to Parquet format.