Administering Relational Databases on Microsoft Azure — Question 31

You have a single availability set that contains two SQL Server on Azure Virtual Machines instances.

The instances were deployed by using an Azure Marketplace SQL Server 2019 Enterprise image that has the latest cumulative updates applied. The instances are configured as the nodes of a failover cluster instance (FCI) named FCI1.

You need to ensure that client applications can connect to FCI1. The solution must meet the following requirements:

• Provide an availability SLA.
• Minimize costs.

What should you create?

Answer options

• A. an Azure Standard Load Balancer
• B. a virtual network name (VNN) resource
• C. a Basic Azure Load Balancer
• D. a distributed network name (DNN) resource

Correct answer: D

Explanation

The correct answer is D, a distributed network name (DNN) resource, as it facilitates client connections to a failover cluster instance while maintaining an availability SLA and minimizing costs. The Azure Standard Load Balancer and Basic Azure Load Balancer do not support the required functionality for a failover cluster, and a virtual network name (VNN) resource does not provide the same benefits as a distributed network name in this context.