Question

A financial services company runs a customer-facing web application backed by Azure SQL Database in the East US region. The database experiences heavy read traffic from reporting dashboards that must not affect the performance of transactional writes. The company also needs the database to survive a full regional outage with an RPO of near-zero and an RTO of under one hour, and they want read replicas positioned close to users in West Europe. Which solution should you recommend?

Accepted Answer

Configure an active geo-replication secondary in West Europe and direct reporting dashboard queries to the readable secondary replica.

Answer

Scale up the primary Azure SQL Database to the Business Critical tier and enable zone-redundant configuration within East US.

Answer

Enable point-in-time restore with long-term retention and restore a copy to West Europe for reporting workloads.

Answer

Migrate the database to a single Azure SQL Managed Instance with a scheduled nightly geo-restore to West Europe.