MENU
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?
Suggested Answer: B
Get Premium DP-300 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
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
11 comments · newest first
TI
Timothy
12 months ago
Azure Site Recovery? That’s more for disaster recovery, not backups.
UN
Una
1 year ago
Automated Backup sounds good, but Azure Backup is more robust.
GE
Genevieve
1 year ago
Wait, can SQL Server Agent jobs really handle this? Not sure about that.
JE
Jeannetta
1 year ago
Definitely agree, Azure Backup is designed for this!
MA
Mariann
1 year ago
I think Azure Backup is the way to go for centralized management.
TW
Twila
1 year 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.
DI
Diane
1 year 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.
LE
Leanora
1 year ago
I’m not entirely sure, but I think SQL Server Agent jobs are more about scheduling tasks rather than centralized backup management.
WA
Walton
1 year 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.
RO
Roxane
1 year 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.
VO
Von
1 year 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.