Medium-Hard Analyze Database Scaling open_ended

Why is a foreign key relationship across shards problematic?

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

Want to see the correct answer?

Get the answer with a detailed explanation, plus practice 21+ more Database Scaling questions with adaptive quizzes and timed interviews.

See the Answer on Guru Sishya →

This question is from the Database Scaling topic (System Design).

Learn Database Scaling → Browse All Questions

More Database Scaling Questions

What is the primary purpose of a read replica in a database setup?

In master-slave replication, replicas can accept write operations.

Which sharding strategy ensures that adding a new shard requires moving minimal data?

What is replication lag and why does it matter?

What is the difference between vertical partitioning and horizontal partitioning (sharding)?