Intermediate
Database Management Systems
Q48 / 100
What is sharding in databases?
Correct! Well done.
Incorrect.
The correct answer is B) Horizontally partitioning data across multiple database servers, each holding a subset of rows (shard), for scalability
B
Correct Answer
Horizontally partitioning data across multiple database servers, each holding a subset of rows (shard), for scalability
Explanation
Sharding scales writes horizontally. Shard key determines which shard holds a row (e.g., user_id % N). Challenges: cross-shard queries, rebalancing, and maintaining ACID across shards.
Progress
48/100