AZ-305 Practice Question 96: SQL VM Workload Backup

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

Business Continuitymedium

A finance company runs SQL Server 2019 on an IaaS virtual machine in Azure. Compliance requires a recovery point objective of 15 minutes for the databases on that VM, along with the ability to restore an individual database to a specific point in time without restoring the whole VM. The company already takes a nightly Azure Backup snapshot of the entire VM for disaster recovery and wants to keep that in place. Which additional capability should you include in the design to meet the 15-minute RPO for the databases?

Select one answer
Show answer and explanation

Answer:

  • C. Configure Azure Backup for SQL Server in Azure VMs, which takes database-aware full, differential and frequent transaction log backups as often as every 15 minutes

Azure Backup's SQL Server workload backup is database aware: it schedules full and differential backups on its own policy and transaction log backups as often as every 15 minutes, which is what delivers a 15 minute RPO and lets an individual database be restored to a specific point in time. It runs alongside the existing VM-level backup without conflict, because VM backups trigger copy-only full backups that do not break the SQL backup chain.

Option A is wrong because VM-level snapshots back up the whole disk image, not individual databases, and taking them every 15 minutes would be both extremely expensive and still incapable of a database-level point-in-time restore. Option B is wrong because Site Recovery replicates the VM for regional disaster recovery failover; it is not a database backup mechanism and does not provide per-database point-in-time restore. Option D is wrong because an availability group provides high availability against a local failure, not a backup or point-in-time restore capability, and a synchronous replica in the same zone does nothing to satisfy a recovery point objective for data loss scenarios like accidental deletion.

Reference: Back up SQL Server databases to Azure

Practice Test 10 ›

Study guides for AZ-305