A financial services company runs a critical SQL Server database on Azure Virtual Machines. They require a disaster recovery solution with an RPO of less than 15 seconds and an RTO of less than 1 hour. Which technology should they implement?
Trap 1: Azure Site Recovery
Incorrect. Azure Site Recovery typically has an RPO of several minutes, which does not meet the sub-15-second requirement.
Trap 2: Azure Backup for SQL Server
Incorrect. Azure Backup provides point-in-time restore but has a typical RPO of hours and RTO that is not suitable for sub-1-hour recovery.
Trap 3: Geo-redundant backups
Incorrect. Geo-redundant backups are for storage-level redundancy and do not provide the required low RPO/RTO for a SQL Server database.
- A
Azure Site Recovery
Why wrong: Incorrect. Azure Site Recovery typically has an RPO of several minutes, which does not meet the sub-15-second requirement.
- B
SQL Server Always On Availability Groups
Correct. Always On Availability Groups with synchronous replication can provide an RPO of zero and an RTO of seconds to minutes, satisfying the disaster recovery requirements.
- C
Azure Backup for SQL Server
Why wrong: Incorrect. Azure Backup provides point-in-time restore but has a typical RPO of hours and RTO that is not suitable for sub-1-hour recovery.
- D
Geo-redundant backups
Why wrong: Incorrect. Geo-redundant backups are for storage-level redundancy and do not provide the required low RPO/RTO for a SQL Server database.