🏗️ System Design Assessment

Distributed systems, scalability, databases & consistency

00:00

Question 1 of 100/10 answered

Distributed Systems· Scenario-based

Q1.The CAP theorem states that a distributed system can only guarantee two of three properties. Which combination does a typical SQL database (like PostgreSQL) prioritise during a network partition?

Availability + Partition Tolerance (AP) — it stays online and accepts writes during partitions

Consistency + Partition Tolerance (CP) — it refuses writes during a partition to avoid returning stale data, prioritising correctness over availability

Consistency + Availability (CA) — but CA is only achievable if you assume partitions never happen

All three — modern databases have overcome CAP theorem limitations

Free · No account needed · Results instant

+20 XP on completion (signed-in users)