An organization has an on-premises virtual machine named VM1 running SQL Server that hosts… — Microsoft Azure Solutions Architect (AZ-305)

An organization has an on-premises virtual machine named VM1 running SQL Server that hosts a critical sales database. You are designing a disaster recovery (DR) solution to Azure. VM1 has the following disk configuration:

* Disk 0 (OS): $120\text{ GB}$ Standard HDD with a write disk churn rate of $1.2\text{ MB/s}$
* Disk 1 (Application): $250\text{ GB}$ Premium SSD with a write disk churn rate of $4.5\text{ MB/s}$
* Disk 2 (Database Log): $500\text{ GB}$ Premium SSD with a write disk churn rate of $18\text{ MB/s}$

The DR solution must meet an RPO of $1\text{ hour}$ and an RTO of $2\text{ hours}$ . Which two actions should you include in the disaster recovery design? (Select two.)

Replicate Disk 0 and Disk 1 to Azure by using Azure Site Recovery.Answer
Configure SQL Server Always On Availability Groups to replicate the database to a SQL Server instance running on an Azure virtual machine.Answer
C
Replicate Disk 2 to Azure by using Azure Site Recovery on a Standard SSD managed disk.
D
Replicate all disks of VM1 (Disk 0, Disk 1, and Disk 2) to Azure by using Azure Site Recovery.
E
Configure Azure Backup to perform continuous backup replication for Disk 2 to an Azure Recovery Services vault.

Answer

Replicate Disk 0 and Disk 1 to Azure by using Azure Site Recovery, and configure SQL Server Always On Availability Groups to replicate the database to a SQL Server instance running on an Azure virtual machine.

The correct options recommend replicating the lower-churn OS and application disks (Disk 0 and Disk 1) using Azure Site Recovery while using SQL Server Always On Availability Groups for the high-churn database workloads on Disk 2. This satisfies the Azure Site Recovery limits (where Standard HDD is limited to

2\text{ MB/s}

and Premium SSD is limited to

10\text{ MB/s}

write churn per disk) and ensures a supported, reliable disaster recovery topology.

Step-by-Step Solution

Analyze the write churn of each disk on VM1 against Azure Site Recovery limits.

Disk 0 (

1.2\text{ MB/s}

) is under the

2\text{ MB/s}

limit for Standard HDD. Disk 1 (

4.5\text{ MB/s}

) is under the

10\text{ MB/s}

limit for Premium SSD. Disk 2 (

18\text{ MB/s}

) exceeds the standard

10\text{ MB/s}

limit per Premium SSD disk.

To determine which disks can be replicated using ASR without replication failures.

Select the appropriate disaster recovery mechanism for the high-churn database disk.

Exclude Disk 2 from Azure Site Recovery and use native database replication (SQL Server Always On Availability Groups) to replicate the database logs and data to Azure.

High-transaction workloads exceeding ASR limits require application-level replication to meet low RPO/RTO goals.

Combine the solutions to design the hybrid disaster recovery plan.

ASR replicates the OS and application disks, while SQL Server Always On replicates the database tier.

This combination ensures all VM components are protected within supported limits while satisfying RPO and RTO constraints.

Key Concept

Azure Site Recovery write churn limits require workload separation or application-level replication for high-transaction database disks.

Estimated Time:2m 0s

Question

Answer

Step-by-Step Solution

Key Concept

Common Mistakes

Topics

More questions from this topic