You have an Azure subscription. You plan to deploy four SQL Server on Azure Virtual Machines instances to two Azure regions. Two instances will be deployed to each region. Each region will host a…

Question

Options

• Aa Hyper-V cluster
• Ba workgroup cluster
• Can Active Directory-detached cluster
• Da Network Load Balancing (NLB) cluster

• A
  22% (13)
• B
  59% (34)
• C
  5% (3)
• D
  14% (8)

Explanation

SQL Server on Azure Virtual Machines, Configure a workgroup availability group You can create an Active Directory domain-independent cluster with an Always On availability group; this is also known as a workgroup cluster. Windows Server 2016 introduced a new type of Windows Server failover cluster based on the foundation of the Active Directory-detached cluster: a workgroup cluster. A workgroup cluster allows SQL Server to deploy an availability group on top of a WSFC that doesn't require AD DS. SQL Server requires the use of certificates for endpoint security, just as the database mirroring scenario requires certificates. This type of an availability group is called a domain independent availability group. Deploying an availability group with an underlying workgroup cluster supports the following combinations for the nodes that will make up the WSFC: https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/availability-group- clusterless-workgroup-configure https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/domain- independent-availability-groups

No community discussion yet for this question.