Question

You are deploying a two-node Always On availability group on Azure virtual machines running SQL Server Enterprise for a mission-critical application. The business requires the highest possible infrastructure availability SLA for the VMs and can tolerate the additional network latency between fault domains. Both replicas must remain protected against a datacenter-level hardware failure. How should you place the two SQL Server VMs?

Accepted Answer

Deploy each VM into a separate availability zone within the same region

Answer

Deploy both VMs into the same availability set within a single datacenter

Answer

Deploy both VMs into a single proximity placement group in one zone

Answer

Deploy each VM into a separate region and use active geo-replication