Microsoft Azure Architect Technologies (2020, legacy) — Question 2

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?

Answer options

Correct answer: C

Explanation

The correct answer is C, an Azure Storage account, as it is required to store the backups and meet the retention and encryption requirements. Option A, Elastic Database jobs, is not relevant for backup automation. Option B, Azure Key Vault, is used for managing encryption keys but does not store backups. Option D, a Recovery Services vault, is focused on VM and application-level backups, not specifically for SQL database storage.