CAP Theorem in Practice

As a Mid-level engineer, explain CAP Theorem in Practice. What problem does it solve and how would you describe it in an interview?

Answers use simple, clear English.