Microsoft Certified: Azure Solutions Architect ExpertDesign business continuity solutionsMedium
A global financial institution uses Azure for its critical trading applications. The institution requires a backup solution for its Azure SQL Database instances that allows for granular, self-service recovery of individual tables and stored procedures, with a recovery point objective (RPO) of 1 hour. Which Azure service should be recommended to meet these requirements?
- AAzure Backup for SQL Server in Azure VMs
- BAzure Site Recovery
- CAzure Blob Storage with immutable policies
- DAzure SQL Database Automated Backups
Show answer & explanationAnswer & explanation
Correct answer: A. Azure Backup for SQL Server in Azure VMs
Azure Backup for SQL Server in Azure VMs provides granular, self-service recovery options for SQL databases running on Azure VMs, including individual tables and stored procedures. This solution can be configured to meet an RPO of 1 hour through frequent log backups.
Why the other options are wrong
- B. Azure Site Recovery focuses on disaster recovery for entire VMs, not granular database object recovery.
- C. Azure Blob Storage with immutable policies is for storing objects immutably and does not provide native SQL database backup and granular recovery capabilities.
- D. Automated backups for Azure SQL Database offer point-in-time restore for the entire database, not granular object recovery.
Azure Backup for SQL Server in Azure VMs
A solution within Azure Backup that provides enterprise-scale backup capabilities for SQL Server databases running on Azure Virtual Machines, offering granular recovery options.
- Supports SQL Server on Azure VMs
- Provides granular database recovery (e.g., tables, stored procedures)
- Integrates with Azure Recovery Services vaults
- Supports various RPO/RTO requirements
Memory trick: SQL Server's Backup Granularity is Key for Azure VMs.