Microsoft DP-300 Exam - Topic 2 Question 73 Discussion

Actual exam question for Microsoft's DP-300 exam

Question #: 73
Topic #: 2

You have an Azure subscription.

Vou need to deploy two instances of SQL Server on Azure virtual machines in a highly available configuration that will use an Always On availability group. The solution must meet the following requirements:

* Minimize how long it takes to fail over.

* Maintain existing connections to the primary replica during a failover.

What should you do?

AConnect each virtual machine to a single subnet on a single virtual network.

BConnect each virtual machine to a single subnet on a virtual network. Deploy a standard Azure load balancer.

CConnect each virtual machine to a different subnet on a single virtual network.

DConnect each virtual machine to a different subnet on a virtual network. Deploy a basic Azure load balancer.

Show Suggested Answer

Suggested Answer: C

by Mitzie at May 30, 2023, 05:36 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Han

4 months ago

Surprised that option D is even on the list, seems less reliable.

upvoted 0 times

...

Elmira

4 months ago

I thought you needed a basic load balancer for high availability?

upvoted 0 times

...

Chi

4 months ago

Isn't it risky to connect to a single subnet?

upvoted 0 times

...

Donte

4 months ago

I disagree, I think option A is simpler and effective.

upvoted 0 times

...

Edna

4 months ago

Option B seems like the best choice for load balancing.

upvoted 0 times

...

Geraldine

5 months ago

I feel like option B makes the most sense since it mentions a load balancer, but I'm uncertain about the specifics of the subnets.

upvoted 0 times

...

Fabiola

5 months ago

I practiced a similar question where connecting VMs to different subnets was recommended, but I can't recall if that applies here.

upvoted 0 times

...

Nobuko

5 months ago

I think deploying a standard Azure load balancer could help with maintaining connections during failover, but I need to double-check the requirements.

upvoted 0 times

...