You are designing a disaster recovery solution for a multi-tier application. The application consists of a web tier, an application tier, and a database tier running SQL Server on Azure VMs. The RPO must be 5 seconds, and the RTO must be 15 minutes. You need to recommend a SQL Server availability solution that meets these requirements. What should you use?
Synchronous commit ensures zero data loss (RPO=0) and automatic failover can achieve RTO under 15 minutes.
Why this answer
Option A is correct because SQL Server Always On Availability Groups with synchronous commit can achieve an RPO of 5 seconds and an RTO of minutes with automatic failover. Option B is wrong because log shipping has a higher RPO (minutes to hours). Option C is wrong because Azure SQL Database Managed Instance automatic backups have an RPO of up to 5 minutes.
Option D is wrong because Azure Site Recovery replication for SQL Server can have an RPO of a few seconds but RTO may exceed 15 minutes due to recovery time.