Medium-HardEvaluateSystem Design Interview FrameworkMultiple 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
AData is no longer durable
BCross-shard queries (e.g., global trending) become expensive scatter-gather operations
CIndividual user queries become slower
DThe 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).
More System Design Interview Framework Questions
What does RADIO stand for in the system design interview framework?
EasyIn a 45-minute system design interview, how many minutes should you spend on the Infrastructure (architecture diagram) phase?
EasyWhich of the following is a NON-functional requirement?
Medium-EasyWhat HTTP status code should a URL shortener return when redirecting a user from the short URL to the original URL?
Medium-EasyWhat is the correct REST URL for retrieving all tweets posted by a specific user?
Medium-Easy