Microsoft DP-300 Exam - Topic 7 Question 10 Discussion

Actual exam question for Microsoft's DP-300 exam

Question #: 10
Topic #: 7

[All DP-300 Questions]

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?

AAutomated Backup in the SQL virtual machine settings

BAzure Backup

CAzure Site Recovery

DSQL Server Agent jobs

Show Suggested Answer

Suggested Answer: B

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

by Franklyn at May 07, 2022, 06:10 PM

Limited Time Offer

25%

Off

Get Premium DP-300 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Timothy

4 months ago

Azure Site Recovery? That’s more for disaster recovery, not backups.

upvoted 0 times

...

Una

4 months ago

Automated Backup sounds good, but Azure Backup is more robust.

upvoted 0 times

...

Genevieve

4 months ago

Wait, can SQL Server Agent jobs really handle this? Not sure about that.

upvoted 0 times

...

Jeannetta

5 months ago

Definitely agree, Azure Backup is designed for this!

upvoted 0 times

...

Mariann

5 months ago

I think Azure Backup is the way to go for centralized management.

upvoted 0 times

...

Twila

5 months ago

Automated Backup sounds familiar, but I’m not confident it offers the centralized management we need. I think Azure Backup is the better option.

upvoted 0 times

...

Diane

5 months ago

I feel like Azure Site Recovery is more for disaster recovery rather than just backups. I might be leaning towards Azure Backup for this question.

upvoted 0 times

...

Leanora

5 months ago

I’m not entirely sure, but I think SQL Server Agent jobs are more about scheduling tasks rather than centralized backup management.

upvoted 0 times

...

Walton

5 months ago

I remember we discussed Azure Backup in class as a centralized solution for managing backups across multiple VMs. It seems like a good fit here.

upvoted 0 times

...

Roxane

5 months ago

Okay, let's see. The question is asking about a performance modeling tool used with IBM Spectrum Virtualize storage systems. That narrows it down a bit. I'm leaning towards option B, IBM Storage Modeller (StorM), since that sounds like it could fit the description.

upvoted 0 times

...

Von

5 months ago

Hmm, I'm a little unsure about this one. Prednisone has a lot of potential side effects, so I'll need to really think through which one is the exception here.

upvoted 0 times

...