ExpertMinds LogoExpertMinds
Medium1 markMultiple Choice
Domain 3.1: Design a solution for backup and disaster recoveryDomain 3Business ContinuityAzure BackupSQL Server

AZ-305 · Question 32 · Domain 3.1: Design a solution for backup and disaster recovery

You are designing a backup strategy for an Azure Virtual Machine running SQL Server.

The business requires a Recovery Point Objective (RPO) of 15 minutes for the database. You decide to use Azure Backup for SQL Server in Azure VMs.

Which TWO statements describe the capabilities and requirements of this solution? (Select TWO)

Answer options:

A.

It supports 15-minute RPO by backing up transaction logs.

B.

It requires the Azure Backup workload extension to be installed on the VM.

C.

It requires the VM to be shut down during the backup process.

D.

It only supports full database backups, not differential or log backups.

E.

It uses Azure Site Recovery to replicate the database to another region.

How to approach this question

Understand how Azure Backup interacts with SQL Server inside an IaaS VM (via an extension) and how it achieves low RPO (via transaction log backups).

Full Answer

It supports 15-minute RPO by backing up transaction logs, and It requires the Azure Backup workload extension to be installed on the VM.
Azure Backup provides a specialized solution for SQL Server running in Azure VMs. It installs a workload extension on the VM that interacts with SQL Server's Virtual Device Interface (VDI). This allows it to perform application-consistent Full, Differential, and Transaction Log backups. By scheduling log backups every 15 minutes, it easily meets the 15-minute RPO requirement without requiring the VM to be shut down.

Common mistakes

Thinking Azure Backup only takes VM-level snapshots. For SQL Server, it has a specialized workload backup that operates at the database level.
31All questions33

Practice the full Azure Solutions Architect Expert AZ-305 Practice Exam 1

55 questions · hints · full answers · grading

Sign up freeTake the exam

More questions from this exam

Q01Contoso Ltd is a global financial institution with 80 Azure subscriptions spread across 4 managem...MediumQ02Fabrikam Inc. operates a hybrid cloud environment with 500 on-premises VMware virtual machines ru...HardQ03A startup company has a single Azure subscription with a monthly budget of $5,000. The CFO want...EasyQ04You are designing an Azure Sentinel architecture for a Managed Security Service Provider (MSSP). ...MediumQ05A healthcare enterprise is migrating its infrastructure to Azure. They have strict compliance req...Hard
View all 55 questions →