Medium-Hard Analyze System Design Interview Framework Multiple Choice

A system has 100K read QPS and 5K write QPS on a single PostgreSQL instance. Which scaling action addresses the bottleneck?

Analyze — Tests ability to break down and examine complex problems.

Answer Options

A Add more application servers

B Shard the database by user_id

C Add Redis cache and read replicas to offload the 100K reads

D Switch to MongoDB for its flexible schema

Want to see the correct answer?

Get the answer with a detailed explanation, plus practice 20+ more System Design Interview Framework questions with adaptive quizzes and timed interviews.

See the Answer on Guru Sishya →

This question is from the System Design Interview Framework topic (System Design).

Learn System Design Interview Framework → Browse All Questions

More System Design Interview Framework Questions

What does RADIO stand for in the system design interview framework?

In a 45-minute system design interview, how many minutes should you spend on the Infrastructure (architecture diagram) phase?

Which of the following is a NON-functional requirement?

What HTTP status code should a URL shortener return when redirecting a user from the short URL to the original URL?

What is the correct REST URL for retrieving all tweets posted by a specific user?