Microsoft DP-300 Exam - Topic 3 Question 77 Discussion

Actual exam question for Microsoft's DP-300 exam

Question #: 77
Topic #: 3

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. The solution must eliminate the need for the following:

* A distributed network name (DNN)

* A load balancer

What should you do?

ADeploy VM1 and VM2 to a single proximity placement group.

BDeploy VM1 and VM2 to different proximity placement groups in the same Azure region.

CConnect VM1 and VM2 to a single subnet.

DConnect VM1 and VM2 to different subnets on a single virtual network.

Show Suggested Answer

Suggested Answer: D

by Jerry at Sep 02, 2023, 11:51 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Nohemi

5 months ago

I thought you still needed a load balancer for failover?

upvoted 0 times

...

Mitsue

5 months ago

Definitely going with A, makes sense for clustering!

upvoted 0 times

...

Sherita

5 months ago

Wait, can you really skip a DNN with this setup?

upvoted 0 times

...

Kerrie

5 months ago

I disagree, I think proximity groups are better.

upvoted 0 times

...

Sherell

5 months ago

Option C is the way to go! Single subnet is key.

upvoted 0 times

...

Jody

6 months ago

I vaguely recall that using different subnets could complicate things, so I’m leaning towards option A or C, but I need to review the details again.

upvoted 0 times

...

Olen

6 months ago

I practiced a similar question where subnetting was involved. I feel like option C could be the answer, but I’m not completely confident.

upvoted 0 times

...

Cammy

6 months ago

I think connecting VM1 and VM2 to a single subnet might be the right approach, but I need to double-check if that meets all the requirements.

upvoted 0 times

...

Vinnie

6 months ago

I remember something about proximity placement groups, but I'm not sure if they really eliminate the need for a DNN or load balancer.

upvoted 0 times

...

Lorrine

6 months ago

I'm not sure about the subnet approach. Wouldn't that still require some kind of load balancing mechanism? Maybe the proximity placement group is the better option here. I'll have to think this through carefully.

upvoted 0 times

...

Kris

6 months ago

Okay, I think I've got this. The solution is to deploy the VMs to different subnets on the same virtual network. That way, they can communicate without needing a DNN or load balancer. Sounds good!

upvoted 0 times

...

Amber

6 months ago

Hmm, I'm a bit confused about the proximity placement group requirement. Does that mean the VMs need to be in the same location? I'll have to research that a bit more.

upvoted 0 times

...

Kenneth

6 months ago

This question seems straightforward. I think the key is to eliminate the need for a DNN and load balancer, so I'll focus on the proximity placement group and subnet options.

upvoted 0 times

...

Mendy

6 months ago

I'm a bit confused by this question. The wording is a bit technical, and I'm not sure I fully grasp the implications of the "smart" stop mode. I'll have to review my notes on PostgreSQL administration.

upvoted 0 times

...