Exam DP-300 topic 6 question 36 discussion

You should create a distributed network name (DNN) resource 1. On Azure Virtual Machines, the DNN routes traffic to the appropriate clustered resource. It provides an easier way to connect to the SQL Server failover cluster instance (FCI) than the virtual network name (VNN), without the need for an Azure Load Balancer 1. So, the correct answer is D

A DNN resource simplifies the configuration and eliminates the need for an Azure Load Balancer, which reduces costs while still providing high availability It is specifically designed for SQL Server failover cluster instances (FCIs) on Azure Virtual Machines and ensures seamless client connectivity Unlike a virtual network name (VNN), a DNN does not require a load balancer, making it a cost-effective solution

D - Based on the requirements: Availability SLA: Both DNN and the Standard Load Balancer meet this requirement. Minimize costs: DNN is the better choice, as it eliminates the need for a Load Balancer, reducing overall infrastructure costs.Stupid question though.

For an alternative connectivity option for SQL Server 2019 CU2 and later, consider a distributed network name (DNN) instead. A DNN offers simplified configuration and improved failover. https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/failover-cluster-instance-vnn-azure-load-balancer-configure?view=azuresql&tabs=ilb

M$ has a habit of providing incomplete descriptions, then asking stupid questions. DNN, VNN, Load Balancer... it all comes down to having the VMs in the same subnet or not. For the exam is D. For real life is to separate the VMs in two different subnets, thus eliminating the need for such stupid things: https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/availability-group-manually-configure-tutorial-single-subnet?view=azuresql. I've done this a number of times, and every single time I chose the path with different subnets.

See the U_C and OBIJUAN88 explanations.

I think they mentioned SLA just to divert us from the main requirement - "You need to ensure that client applications can connect to FCI1", so there are 2 nodes and they have VNN but you need sort of a DNS name (which is DNN here) to connect to the cluster. So D is a correct answer

It's obviously A!!!

sorry ignore my comment, dnn is selected here

this is wrong. it's a DNN GOOGLE search "configure a dnn for failover cluster instance" and look for ms learn link

The correct answer is C: Create a load balancer with a public IP address and a Basic SKU. Then, configure the load balancer to use a backend pool that includes the two virtual machines in the availability set. Finally, create a health probe that checks the SQL Server database engine service port on each virtual machine.