Advanced
System Design
Q97 / 100
When scaling a relational database vertically reaches its limits, and sharding introduces too much complexity for a team, what is a common intermediate strategy?
Correct! Well done.
Incorrect.
The correct answer is A) Introducing read replicas for read-heavy workloads, caching frequently accessed data, and optimizing queries/indexes before resorting to full sharding
A
Correct Answer
Introducing read replicas for read-heavy workloads, caching frequently accessed data, and optimizing queries/indexes before resorting to full sharding
Explanation
Before the operational complexity of sharding, teams often exhaust simpler scaling levers: read replicas for read scaling, caching layers (Redis/Memcached) to reduce database load, and query/index optimization.
Progress
97/100