CAP Theorem

Problem

Your team is evaluating a new NoSQL distributed database. It claims to be 100% available and 100% strongly consistent even when the network between data centers is cut, which you know is mathematically impossible. Write a query that outputs a column theorem with the value: "A distributed datastore can only guarantee two of the following: Consistency, Availability, Partition tolerance."

Database Schema

This problem acts as a scratchpad. You will write your own DDL/DML or conceptual queries, so there is no predefined schema.

Try It

Hint

Solution