DP-300 Certification Practice Question #211

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?

Accepted Answer

To centrally manage database backups across 10 SQL Server Azure VMs and support restoring individual databases to alternate instances, Azure Backup (option B) is the ideal solution. It integrates with Azure Recovery Services vaults to provide centralized backup policy management, monitoring, and alerts. Additionally, it supports Alternate Location Restore (ALR), allowing databases to be restored to any registered SQL Server instance in the same region. Other solutions, like Automated Backup (option A) or SQL Server Agent jobs (option D), require local configuration on each VM and do not provide centralized governance.

More DP-300 practice questions