ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam AZ-303 All Questions

View all questions & answers for the AZ-303 exam
Go to Exam

Exam AZ-303 topic 2 question 32 discussion

Actual exam question from Microsoft's AZ-303
Question #: 32
Topic #: 2
[All AZ-303 Questions]

You have SQL Server on an Azure virtual machine named SQL1.
You need to automate the backup of the databases on SQL1 by using Automated Backup v2 for the virtual machines. The backups must meet the following requirements:
✑ Meet a recovery point objective (RPO) of 15 minutes.
✑ Retain the backups for 30 days.
✑ Encrypt the backups at rest.
What should you provision as part of the backup solution?

  • A. Elastic Database jobs
  • B. Azure Key Vault
  • C. an Azure Storage account
  • D. a Recovery Services vault
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
An Azure storage account is used for storing Automated Backup files in blob storage. A container is created at this location to store all backup files. The backup file naming convention includes the date, time, and database GUID.
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/automated-backup
by David_986969 at Aug. 27, 2020, 6:08 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
H
Highly Voted 4 years, 11 months ago
Correct, it states that they want to use Automated Backup v2 and therefore need a storage account to use for storing Automated Backup files in blob storage
upvoted 44 times
AnonymousJhb
4 years, 3 months ago
C is correct, as per the given url: use the New-AzVMSqlServerAutoBackupConfig command to enable and configure the Automated Backup v2 settings to store backups in the Azure storage account.
upvoted 7 times
...
Cramster
4 years ago
Agreed, https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/automated-backup#configure-automated-backup-v2 mentions that a storage account is required
upvoted 6 times
...
...
ingoo
Highly Voted 4 years, 10 months ago
The trick thing is SQL Server on Azure VM, not Azure SQL, therefore the answer is correct
upvoted 16 times
...
sandeepmalik
Most Recent 3 years, 4 months ago
In today's exam. Score 900+ Correct answer.
upvoted 1 times
...
JDS11
3 years, 5 months ago
Selected Answer: C
storage account
upvoted 1 times
...
nd78
3 years, 6 months ago
on Exam today 21st Jan, 2022
upvoted 2 times
...
tomatosis
3 years, 7 months ago
On exam 23 Dec 2021
upvoted 1 times
...
Dpejic
3 years, 8 months ago
On exam today 22/11/21. r. Score 839
upvoted 2 times
...
edmacoar123
3 years, 8 months ago
On exam today 19/11/21. Correct answer. Score 860.
upvoted 5 times
...
akashsanu
3 years, 10 months ago
the storage account is the correct answer for all the automated backup.
upvoted 1 times
...
syu31svc
3 years, 11 months ago
Elastic Database jobs - Elastic jobs lets you run a set of T-SQL scripts against a collection of servers or databases, as a one-time job, in an ad-hoc manner. Not required to take database backups. Azure Key Vault - Azure key vault is not required for automated database backups. A Recovery Services vault - A Recovery Services vault is a storage entity in Azure that houses data. You can use Recovery Services vaults to hold backup data for various Azure services such as IaaS VMs (Linux or Windows) and Azure SQL databases. Automated Backup v2 feature does not require a recovery services vault. C is the answer
upvoted 5 times
...
MinhajR
3 years, 11 months ago
On Exam 27/08/2021
upvoted 2 times
...
VMUN
4 years, 1 month ago
26-June-21, Passed the exam. Correct Answer
upvoted 3 times
...
jd94
4 years, 1 month ago
6/12/2021. Passed the exam. Storage Account
upvoted 3 times
...
battleneter
4 years, 1 month ago
D= Wrong as a "Recovery Services vault" helps manage VM backups not SQL, which leaves the only other logical answer C.
upvoted 1 times
...
betamode
4 years, 2 months ago
Option C (Storage account) is the correct answer in this case. D (Recovery service vault) could have been the right option if backups were performed using Azure Backup service. There are 3 ways to backup a SQL Server on VM (IAAS) in Azure: (1) Automated backup or automated backup v2 which is mentioned in this question. Automated backup v2 uses storage account not recovery service vault so, this is the right answer for this specific question / scenario. (2) Azure backup for SQL VMs - this service uses Recovery service vault but for the current scenario / question, we are not using this method to backup SQL so, Recovery services vault is incorrect. (3) - Manual Backup. Again, to summarize - This question is talking about 1st method Automated backup v2 which used storage account and that's why option C (Storage Account) is the right option. Hope that clarifies the confusion.
upvoted 9 times
betamode
4 years, 2 months ago
Documentation URL which talks about 3 methods listed above - https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/backup-restore#:~:text=Machines-,Azure%20Backup%20for%20SQL,operations%20through%20the%20portal
upvoted 1 times
...
...
chen17
4 years, 2 months ago
On exam 5/15/2021
upvoted 5 times
...
whynotguru
4 years, 2 months ago
Automated Backup allows you to schedule regular backups for all databases on a SQL Server VM. Backups are stored in Azure storage for up to 30 days. Beginning with SQL Server 2016, Automated Backup v2 offers additional options such as configuring manual scheduling and the frequency of full and log backups.
upvoted 1 times
...
Load full discussion...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel