Medium-Hard Evaluate System Design Interview Framework Multiple Choice

What is the trade-off introduced by sharding a database by user_id?

Evaluate — Tests ability to make judgments and justify decisions.

Answer Options

A Data is no longer durable
B Cross-shard queries (e.g., global trending) become expensive scatter-gather operations
C Individual user queries become slower
D The database can no longer use indexes

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?

Easy

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

Easy

Which of the following is a NON-functional requirement?

Medium-Easy

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

Medium-Easy

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

Medium-Easy