Microsoft
DP-300 · Question #23
You have 10 Azure virtual machines that have SQL Server installed. You need to implement a backup strategy to ensure that you can restore specific databases to other SQL Server instances. The…
The correct answer is B. Azure Backup. Azure Backup provides an Enterprise class backup capability for SQL Server on Azure VMs. All backups are stored and managed in a Recovery Services vault. There are several advantages that this solution provides, especially for Enterprises…
Submitted by obi.ng· Mar 6, 2026Plan and implement a HADR environment
Question
You have 10 Azure virtual machines that have SQL Server installed. You need to implement a backup strategy to ensure that you can restore specific databases to other SQL Server instances. The solution must provide centralized management of the backups. What should you include in the backup strategy?
Options
- AAutomated Backup in the SQL virtual machine settings
- BAzure Backup
- CAzure Site Recovery
- DSQL Server Agent jobs
How the community answered
(47 responses)- A13% (6)
- B79% (37)
- C2% (1)
- D6% (3)
Explanation
Azure Backup provides an Enterprise class backup capability for SQL Server on Azure VMs. All backups are stored and managed in a Recovery Services vault. There are several advantages that this solution provides, especially for Enterprises. https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/backup- restore#azbackup
Community Discussion
No community discussion yet for this question.