Intermediate
Big Data & Data Engineering
Q52 / 100
Why might a table be both "partitioned" by date and "bucketed" by a column like user_id?
Correct! Well done.
Incorrect.
The correct answer is A) Partitioning prunes data by date ranges, while bucketing further organizes data within partitions to speed up joins and aggregations on a key
A
Correct Answer
Partitioning prunes data by date ranges, while bucketing further organizes data within partitions to speed up joins and aggregations on a key
Explanation
Combining partitioning (coarse-grained pruning, e.g., by date) with bucketing (hashing rows into fixed buckets by a key) optimizes both scan and join performance.
Progress
52/100