Question

A financial services company runs a mission-critical application on Azure SQL Managed Instance in the East US region. Compliance requires that the database remain readable and available for reporting even if the primary region experiences an outage, and that failover to a secondary region can occur with minimal manual intervention while preserving the same connection endpoint for the application. Which capability should you implement to meet these requirements?

Accepted Answer

Configure an auto-failover group between two Managed Instances in different regions and connect the application through the read-write and read-only listener endpoints.

Answer

Enable zone-redundant configuration on the existing Managed Instance in East US.

Answer

Schedule geo-restore from automated backups to a Managed Instance in a secondary region on a nightly basis.

Answer

Create an active geo-replication secondary database from the Managed Instance to a second region.