You have an Azure subscription that contains two instances of SQL Server on Azure Virtual Machines named VM1 and VM2. Both instances run Microsoft SQL Server 2019 CU8. You need to deploy a failover…

The correct answer is D. node majority with a disk witness. https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/hadr-cluster-best- practices?view=azuresql&tabs=windows2012#quorum The disk witness is the most resilient quorum option, but to use a disk witness on a SQL Server on Azure VM, you must use an Azure…

Submitted by brentm· Mar 6, 2026Plan and configure a high availability and disaster recovery (HA/DR) environment

Question

You have an Azure subscription that contains two instances of SQL Server on Azure Virtual Machines named VM1 and VM2. Both instances run Microsoft SQL Server 2019 CU8. You need to deploy a failover cluster instance (FCI) to VM1 and VM2 that will use Azure shared disks. The solution must maximize resiliency. Which quorum option should you use?

Options

Anode majority with a cloud witness
Bnode majority with no witness
Cnode majority with a file share witness
Dnode majority with a disk witness

How the community answered

(31 responses)

A
6% (2)
B
3% (1)
C
16% (5)
D
74% (23)

Explanation

https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/hadr-cluster-best- practices?view=azuresql&tabs=windows2012#quorum The disk witness is the most resilient quorum option, but to use a disk witness on a SQL Server on Azure VM, you must use an Azure Shared Disk which imposes some limitations to the high availability solution. As such, use a disk witness when you're configuring your failover cluster instance with Azure Shared Disks, otherwise use a cloud witness whenever possible.

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice