You are designing a business continuity solution for a globally distributed SaaS application that uses Azure Cosmos DB for its operational store. The application must survive a complete regional outage with zero data loss and automatic failover. What should you use?
Strong consistency ensures RPO=0, and automatic failover meets RTO.
Why this answer
Option D is correct because Cosmos DB multi-region writes with the strong consistency mode in a single-region write configuration ensures no data loss (RPO=0) and automatic failover via the service-managed failover policy. Option A is wrong because multi-region writes with eventual consistency can result in data loss. Option B is wrong because a single-region write with eventual consistency has an RPO > 0.
Option C is wrong because Azure SQL Database geo-replication is not the right service.