AZ-305 Practice Question 86: SQL Database Geo Restore

Microsoft Azure Solutions Architect Expert (AZ-305) · Test 9 · question 6 of 10

Business Continuityeasy

A small internal reporting database on Azure SQL Database (General Purpose tier) is used by a few analysts during business hours. If the primary region has an outage, the business can tolerate losing up to an hour of data and can wait several hours before the database is usable again. The team does not want to pay for a standby replica or a failover group and wants the recovery mechanism to use backups the database is already taking.

Which recovery approach should you recommend?

Select one answer
Show answer and explanation

Answer:

  • B. Rely on geo-restore to create a new database from the geo-redundant backups in a different region when the outage occurs

Geo-restore creates a new database in any region from the automated backups that Azure SQL Database already replicates through geo-redundant storage. It needs no standby compute and no additional configuration ahead of time, which fits a workload where cost matters more than recovery speed. Geo-replicated backups can lag the primary by up to about an hour, and a restore typically takes minutes to hours depending on database size, which matches the relaxed RPO and RTO in the scenario, at no cost beyond the backups the database already takes.

Option A gives a much lower RTO through a standby secondary, but that secondary is billed continuously, which the scenario explicitly wants to avoid for a low-priority workload.

Option C protects against the loss of a single availability zone within a region, not the loss of an entire region, so it does not address a regional outage at all.

Option D is not a supported disaster recovery mechanism for Azure SQL Database; the platform does not offer transactional replication to a secondary region as a built-in geo-recovery feature for this scenario.

Reference: Recover an Azure SQL Database using automated database backups

Practice Test 9 ›

Study guides for AZ-305