Explain the CAP theorem and its practical implications. Give me examples of when you would choose consistency over availability, and vice versa. How does this influence your technology choices?

Sample answer preview

The CAP theorem states that a distributed system can provide at most two of three guarantees simultaneously: Consistency, Availability, and Partition Tolerance. Let me break this down practically. Consistency means every read receives the most recent write or an error.