SnowPro Advanced: Architect — Question 127

An Architect is having query performance issues with data stored in external tables and wants to try partitioning the data.

How should the data be partitioned?

Answer options

• A. Partition the data based on the source file size to evenly distribute the data across multiple partitions.
• B. Partition the data based on a specific column that is frequently used in queries to reduce data scanning.
• C. Partition the data based on the file format used for storing the data in external tables.
• D. Partition the data randomly to ensure equal distribution across all available compute resources.

Correct answer: B

Explanation

The correct answer is B because partitioning the data by a specific column that is frequently used in queries can significantly improve query performance by minimizing the amount of data scanned. Option A is incorrect as source file size does not enhance query efficiency. Option C does not address query performance directly, and option D may lead to uneven data distribution, which does not optimize query execution.