Microsoft Exam DP-300 Topic 12 Question 81 Discussion

Actual exam question for Microsoft's DP-300 exam

Question #: 81
Topic #: 12

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?

Aa virtual network name (VNN) resource

Ba Basic Azure Load Balancer

Ca distributed network name (DNN) resource

Dan Azure Standard Load Balancer

Show Suggested Answer

Suggested Answer: C

by Pete at Dec 13, 2023, 10:25 PM

Limited Time Offer

25%

Off

Get Premium DP-300 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Leonor

8 months ago

I'm not sure about the load balancer options. Aren't those usually more for web traffic? Since this is a SQL Server FCI, I think the DNN resource is the best fit. It's designed specifically for this use case, and it should be more reliable than a generic load balancer.

upvoted 0 times

...

Willodean

8 months ago

Hold on, what about option D? An Azure Standard Load Balancer could also provide the availability SLA we need, and it might be more straightforward to set up than the DNN resource. But you're right, the DNN could be more cost-effective.

upvoted 0 times

...

Natalie

8 months ago

I agree, the DNN resource seems like the way to go. It provides a highly available client access point for the FCI1 cluster, and since it's a native Azure feature, it should be more cost-effective than setting up a load balancer.

upvoted 0 times

...

8 months ago

Option C) a distributed network name (DNN) resource seems like the best choice to meet all the requirements.

upvoted 0 times

...