Question

A retail company runs an application backed by four related Azure SQL databases on a single logical server in the East US region. Leadership requires that, in a regional outage, all four databases fail over together to West US as a group, and the application's connection strings must not need to change after failover. Which HA/DR configuration best meets these requirements?

Accepted Answer

Configure an auto-failover group on the logical server that includes all four databases and connect the application using the failover group's read-write listener endpoint.

Answer

Configure active geo-replication individually on each of the four databases to a secondary server in West US and update connection strings after failover.

Answer

Enable zone-redundant configuration on the databases so they automatically fail over within the region and across regions.

Answer

Configure a Always On availability group across the two regions and add all four databases to the same availability group.