Explain CAP theorem and its application in database systems.

Answer preview

Distributed database questions cover replication, sharding, consistency models, and migration strategies at production scale. Explain CAP theorem and its application in database systems. — define the concept, explain how it works in production, and call out trade-offs and failure…