Intermediate
System Design
Q50 / 100
What is the difference between "horizontal" and "vertical" partitioning, and which generally scales better for very large systems?
Correct! Well done.
Incorrect.
The correct answer is A) Horizontal partitioning (sharding) splits rows across servers and generally scales better for large systems since it distributes both data and load
A
Correct Answer
Horizontal partitioning (sharding) splits rows across servers and generally scales better for large systems since it distributes both data and load
Explanation
Horizontal partitioning (sharding by row) distributes both storage and query load across many servers, which is typically more effective for scaling very large datasets than vertical (column-based) partitioning alone.
Progress
50/100