Question

A retail company runs a mission-critical stateful application on Azure Database for MariaDB... no — the application runs on a single Azure SQL Database in the General Purpose tier. Business requires that in a full regional outage the database be recoverable in another Azure region within 1 hour (RTO) with no more than 5 minutes of data loss (RPO). The team wants the lowest operational overhead and does not want to manage replication manually. Which solution should you recommend?

Accepted Answer

Configure an active geo-replication secondary in the target region and use a failover group with automatic failover policy.

Answer

Enable geo-redundant backup storage and rely on geo-restore to the paired region when needed.

Answer

Schedule automated exports of the database to a BACPAC file in geo-redundant Blob storage every 5 minutes.

Answer

Upgrade the database to the Business Critical tier to obtain zone-redundant replicas in the primary region.