Exam DP-300 topic 6 question 2 discussion

Actual exam question from Microsoft's DP-300

Question #: 2
Topic #: 6

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?

A. Automated Backup in the SQL virtual machine settings
B. Azure Backup
C. Azure Site Recovery
D. SQL Server Agent jobs

Show Suggested Answer

Suggested Answer: B 🗳️

by Nutlatte at Oct. 28, 2020, 5:03 p.m.

Comments

Submit Cancel

7Stars

Highly Voted 4 years, 1 month ago

B is correct. With Azure Backup you can centrally manage backups for multiple servers and thousands of databases. but Automated backup allows you to schedule regular backups for all databases on a SQL Server VM. https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/backup-restore#azbackup

upvoted 13 times

...

Chunchi

Most Recent 2 years, 11 months ago

Selected Answer: B

B is correct

upvoted 3 times

...

AmitB

3 years, 3 months ago

Given Answer is correct B, catch in the question is "ensure that you can restore specific databases to other SQL Server instances"

upvoted 2 times

Dalamain

8 months ago

first bullet point: https://learn.microsoft.com/en-us/azure/backup/restore-sql-database-azure-vm#restore-prerequisites

upvoted 1 times

...

Nutlatte

4 years, 1 month ago

A - https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/automated-backup

upvoted 1 times

ramelas

3 years ago

A is to backup the virtual machine and all that is inside at the same time, you cant do a backup of a single database into another server or on the same server. with this option you can only restore a virtual machine to her previous state

upvoted 2 times

...

U_C

3 years, 8 months ago

Answer is Correct: Automated Backup only support a SQL Server VM but Azure Backup provides an Enterprise class backup capability for SQL Server on Azure VMs. With this service, you can centrally manage backups for multiple servers and thousands of databases. In the question, there are 10 Azure SQL Server VM.

upvoted 3 times

OneplusOne

1 year, 11 months ago

Agreed, answer is B: automated backup is only supported on target databases from the default instance, or a single named instance. If there is no default instance, and multiple named instances, the SQL IaaS extension fails and automated backup will not work.

upvoted 1 times

...