Advanced
SQL
Q88 / 100
What is the purpose of "PARTITIONING" a large table (e.g. by date range)?
Correct! Well done.
Incorrect.
The correct answer is B) It splits a large table into smaller physical pieces based on a partitioning key, allowing the database to scan only relevant partitions ("partition pruning") and easing maintenance tasks like archiving old data
B
Correct Answer
It splits a large table into smaller physical pieces based on a partitioning key, allowing the database to scan only relevant partitions ("partition pruning") and easing maintenance tasks like archiving old data
Explanation
Table partitioning divides data into segments (e.g. by month), so queries filtering on the partition key can skip irrelevant partitions entirely, and maintenance operations (like dropping old data) can operate on whole partitions efficiently.
Progress
88/100