You have an Azure subscription. You plan to create an instance of SQL Server on Azure Virtual Machines. You need to ensure that the instance is resilient against datacenter failures. What should you…

Question

Options

• AAzure Site Recovery
• Ba proximity placement group
• Can availability set
• Dan availability zone

• A
  78% (25)
• B
  13% (4)
• C
  3% (1)
• D
  6% (2)

Explanation

Explanation

Azure Site Recovery (ASR) is the correct choice because it provides disaster recovery by replicating virtual machines (including SQL Server VMs) to a secondary Azure region, ensuring the workload remains available even if an entire datacenter or region fails. ASR continuously replicates your VM and enables failover to a replica in another region, directly addressing the requirement for resilience against datacenter failures.

Why the distractors are wrong:

• Proximity placement group (B) does the opposite - it keeps VMs physically close together to reduce latency, offering no protection against datacenter failures.
• Availability set (C) protects against hardware failures within a single datacenter by distributing VMs across fault and update domains, but it does not protect against an entire datacenter going down.
• Availability zone (D) spreads VMs across physically separate buildings within the same region, which protects against single-facility failures but not a full regional/datacenter outage - and it's less relevant for cross-region disaster recovery scenarios.

Memory Tip: Think of the scale of failure: Site Recovery = Separate region = survives the biggest disasters. The bigger the failure scope you need to survive, the more "drastic" your solution needs to be - and ASR is the most drastic (and powerful) option here.

No community discussion yet for this question.