Question

You manage a two-node Always On availability group on SQL Server 2022 VMs in Azure, with both replicas in the same region and Availability Zone-aligned. The business requires zero data loss (RPO = 0) on automatic failover, but a recent audit shows transaction latency increased after the AG was deployed. The primary replica currently uses asynchronous-commit mode with manual failover. Which configuration change best meets the RPO = 0 automatic failover requirement?

Accepted Answer

Set both replicas to synchronous-commit mode and configure automatic failover mode.

Answer

Keep asynchronous-commit mode but change the failover mode to automatic.

Answer

Add a third asynchronous-commit replica in a paired region and enable automatic failover to it.

Answer

Set the primary to synchronous-commit and leave the secondary in asynchronous-commit mode with automatic failover.