Question

A retail company runs a mission-critical order-processing database on Azure SQL Database (General Purpose). The business defines an RTO of 5 minutes and an RPO of 5 seconds for a full regional outage. The current configuration relies only on the built-in geo-redundant backups, and during a recent DR drill the team measured a recovery time of over an hour using geo-restore. Which configuration change should you implement to meet both the RTO and RPO requirements?

Accepted Answer

Configure an auto-failover group with a readable secondary in a paired region and set automatic failover policy.

Answer

Increase the point-in-time restore retention period to 35 days and rely on geo-restore during an outage.

Answer

Enable a long-term retention (LTR) policy with weekly and monthly backups replicated to the secondary region.

Answer

Create a copy of the database in the secondary region nightly using the CREATE DATABASE ... AS COPY OF command.