CAP Theorem in Practice

As a Tech Lead 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.