Microsoft Exam DP-300 Topic 9 Question 104 Discussion

Actual exam question for Microsoft's DP-300 exam

Question #: 104
Topic #: 9

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 Justine at Sep 15, 2024, 02:01 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Regenia

2 months ago

Failover? More like 'Fail-over-and-over-again' if you don't choose the right option. B is the way to go, people. Let's not make this a high stakes game of 'Guess the Azure Solution'.

upvoted 0 times

Deeanna

14 days ago

Agreed, B is the way to go to ensure a smooth failover process.

upvoted 0 times

...

Dalene

19 days ago

B is definitely the best option for this scenario.

upvoted 0 times

...

Judy

1 months ago

C) Connect each virtual machine to a different subnet on a single virtual network.

upvoted 0 times

...

Stephanie

1 months ago

B) Connect each virtual machine to a single subnet on a virtual network. Deploy a standard Azure load balancer.

upvoted 0 times

...

Sarah

2 months ago

Option A? Really? Connecting each VM to a single subnet? That's just asking for trouble. Clearly, the correct answer is B. The standard load balancer is the way to go, my dudes.

upvoted 0 times

Carmela

1 months ago

Definitely, Option B is the best solution for deploying SQL Server instances in a highly available configuration.

upvoted 0 times

...

Rosio

1 months ago

I agree, Option B is the correct choice. The standard load balancer will help maintain existing connections during failover.

upvoted 0 times

...

Tony

1 months ago

Option A? Really? Connecting each VM to a single subnet? That's just asking for trouble.

upvoted 0 times

...

Daryl

2 months ago

I'd say Option C is the best choice here. Connecting each VM to a different subnet on a single virtual network should provide the high availability and failover capabilities required.

upvoted 0 times

Erasmo

1 months ago

Let's go with Option C then. It seems like the most reliable choice.

upvoted 0 times

...

Sheridan

1 months ago

I agree, having each VM on a different subnet is key for failover.

upvoted 0 times

...

Deandrea

1 months ago

Option C is definitely the way to go. It will help with high availability.

upvoted 0 times

...

Theodora

2 months ago

Hmm, I'm leaning towards Option D. A basic load balancer should do the trick and it's a more cost-effective solution. As long as it meets the requirements, why pay more?

upvoted 0 times

...

Alica

3 months ago

But deploying a standard Azure load balancer will help maintain existing connections during failover.

upvoted 0 times

...

Marci

3 months ago

I disagree, I believe the answer is C.

upvoted 0 times

...

Alica

3 months ago

I think the answer is B.

upvoted 0 times

...

Bok

3 months ago

Option B is the way to go. The standard Azure load balancer will help minimize failover time and maintain existing connections during the process. Seems like the most efficient solution to me.

upvoted 0 times

Melodie

2 months ago

Option B is the way to go. The standard Azure load balancer will help minimize failover time and maintain existing connections during the process. Seems like the most efficient solution to me.

upvoted 0 times

...

Vashti

2 months ago

B) Connect each virtual machine to a single subnet on a virtual network. Deploy a standard Azure load balancer.

upvoted 0 times

...