DP-300 · Question #305
DP-300 Question #305: Real Exam Question with Answer & Explanation
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 Shared
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
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.