Explain the CAP theorem and its practical implications. How does it influence database selection and system design decisions in distributed applications?

Sample answer preview

## What is the CAP Theorem? The CAP theorem, formulated by Eric Brewer, states that a distributed data store can provide at most two of the following three guarantees simultaneously: ### Consistency (C) Every read receives the most recent write or an error.