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