Administering Relational Databases on Microsoft Azure — Question 24

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?

Answer options

• A. node majority with a cloud witness
• B. node majority with no witness
• C. node majority with a file share witness
• D. node majority with a disk witness

Correct answer: D

Explanation

The correct answer is D because using a disk witness provides a reliable quorum mechanism in a failover cluster when utilizing Azure shared disks. The other options either lack a witness or use witnesses that may not be as effective in maintaining cluster availability in this specific environment.