Intermediate
Big Data & Data Engineering
Q80 / 100
What is the benefit of "partition pruning" when querying a partitioned table?
Correct! Well done.
Incorrect.
The correct answer is A) The query engine skips scanning partitions that cannot contain relevant data based on filter conditions, reducing I/O
A
Correct Answer
The query engine skips scanning partitions that cannot contain relevant data based on filter conditions, reducing I/O
Explanation
When a query filters on the partitioning column (e.g., WHERE date = '2024-01-01'), the engine can skip irrelevant partitions entirely, greatly improving performance.
Progress
80/100