Microsoft Exam DP-300 Topic 4 Question 72 Discussion

Actual exam question for Microsoft's DP-300 exam

Question #: 72
Topic #: 4

You have an Azure subscription that uses a domain named contoso.com.

You have two Azure VMs named DBServer1 and DBServer2. Each of them hosts a default SQL Server instance. DBServer1 is in the East US Azure region and contains a database named Database

ADBServer2 is in the West US Azure region.
DBServer1 has a high volume of data changes and low latency requirements for data writes.
You need to configure a new availability group for DatabaseA. The secondary replica will reside on DBServer2.
What should you do?

AConfigure the primary endpoint as TCP://DBServer1.contoso.com:445, configure the secondary endpoint as TCP://DBServer2.contoso.com:445, and set the availability mode to Asynchronous.

BConfigure the primary endpoint as TCP://DBServer1.contoso.com:445, configure the secondary endpoint as TCP://DBServer2.contoso.com:445, and set the availability mode to Synchronous.

CConfigure the primary endpoint as TCP://DBServer1.contoso.com:5022, configure the secondary endpoint as TCP://DBServer2.contoso.com:5022, and set the availability mode to Asynchronous.

DConfigure the primary endpoint as TCP://DBServer1.contoso.com:5022, configure the secondary endpoint as TCP://DBServer2.contoso.com:5022, and set the availability mode to Synchronous.

Show Suggested Answer

Suggested Answer: D

by Viva at Apr 22, 2023, 08:07 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Olive

23 days ago

Ah, the joys of managing Azure VMs and SQL Servers. I hope they don't ask us to spin up a data center in our living room next!

upvoted 0 times

Alyce

6 days ago

Managing Azure VMs and SQL Servers can be challenging at times.

upvoted 0 times

...

Sherman

1 months ago

This question is making me thirsty for a nice cold beverage. Maybe I should have a SQL Server while I work on this...

upvoted 0 times

...

Tequila

1 months ago

I bet we'll need to set up some kind of load balancing or failover between the two SQL Server instances. Gotta make sure that database is highly available!

upvoted 0 times

Lettie

2 days ago

Let's make sure to configure the necessary settings to ensure high availability for the Database.

upvoted 0 times

...

Rodolfo

6 days ago

That's a good idea. We can also set up SQL Server Always On Availability Groups for automatic failover.

upvoted 0 times

...

Oliva

14 days ago

We could use Azure Load Balancer to distribute traffic between the two SQL Server instances.

upvoted 0 times

...

Peggie

28 days ago

With these solutions in place, we can ensure high availability for the Database in case one of the VMs goes down.

upvoted 0 times

...

Dannie

29 days ago

That's a good idea! We can also set up Azure Traffic Manager to route traffic to the active SQL Server instance.

upvoted 0 times

...

Leeann

1 months ago

We could use Azure SQL Database Geo-Replication to replicate the database from DBServer1 to DBServer2.

upvoted 0 times

...

Gracia

2 months ago

I think the question in the exam might ask us to configure replication between DBServer1 and DBServer2 for Database.

upvoted 0 times

...

Maile

2 months ago

Hmm, looks like we need to configure DNS to access the database on those VMs. Wonder if we can use the contoso.com domain for that?

upvoted 0 times

Hannah

19 days ago

You can set up DNS records to point to the IP addresses of DBServer1 and DBServer2 within the contoso.com domain.

upvoted 0 times

...

Deandrea

24 days ago

Yes, you can configure DNS to access the database on those VMs using the contoso.com domain.

upvoted 0 times

...

Teri

2 months ago

I have two Azure VMs, DBServer1 and DBServer2.

upvoted 0 times

...

Gracia

2 months ago

I have an Azure subscription with contoso.com domain.

upvoted 0 times

...