Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft DP-300 Exam - Topic 4 Question 72 Discussion

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
D) Configure 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.
A) DBServer2 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?
A) Configure 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.
B) Configure 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.
C) Configure 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.

Microsoft DP-300 Exam - Topic 4 Question 72 Discussion

Actual exam question for Microsoft's DP-300 exam
Question #: 72
Topic #: 4
[All DP-300 Questions]

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

Show Suggested Answer Hide 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:

0/2000 characters
Submit Cancel
Annelle
10 months ago
Totally agree, Synchronous is better for consistency!
upvoted 0 times
...
Caprice
10 months ago
Wait, why would you use port 445? Isn't that for SMB?
upvoted 0 times
...
Gayla
11 months ago
Asynchronous might be risky with high data changes.
upvoted 0 times
...
Micheal
11 months ago
I think Synchronous is the way to go for low latency!
upvoted 0 times
...
Virgina
11 months ago
DBServer1 is in East US, DBServer2 in West US.
upvoted 0 times
...
Dorothea
11 months ago
I think the primary endpoint should definitely be 445, but I'm confused about whether to choose synchronous or asynchronous for the availability mode.
upvoted 0 times
...
Basilia
11 months ago
I feel like we practiced a similar question where we had to choose between synchronous and asynchronous. I think synchronous is better for high availability, but it might not fit here.
upvoted 0 times
...
Mohammad
11 months ago
I'm not entirely sure, but I think the port number might be important. Was it 5022 for the primary endpoint?
upvoted 0 times
...
Rose
11 months ago
I remember we discussed the importance of latency for data writes, so I think we might need to go with asynchronous mode for this setup.
upvoted 0 times
...
Susana
11 months ago
I'm pretty confident I know the correct answer, but I'll double-check the details in the exhibit to be sure.
upvoted 0 times
...
Veronika
11 months ago
Okay, let's see. I know that each host can be a member of multiple groups, but I'm not sure about the limits on the number of groups or group types. Gotta read the options closely.
upvoted 0 times
...
Corazon
12 months ago
Hmm, I'm a bit unsure about the directory structure here. Do I need to create the /home/sandy/ansible/roles directory first, or will it be created automatically? I'll double-check the instructions to make sure I have the steps right.
upvoted 0 times
...
Magnolia
12 months ago
Okay, let me think this through step-by-step. The question is asking about the auditor assessing control risk higher than necessary, which increases substantive testing. I need to match that to the situations depicted in the diagram. I've got this!
upvoted 0 times
...
Olive
1 year 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
Leontine
1 year ago
Definitely, and staying on top of updates and security patches is crucial.
upvoted 0 times
...
Tijuana
1 year ago
It's important to keep track of all the configurations and settings.
upvoted 0 times
...
Vallie
1 year ago
I know, especially when you have multiple VMs in different regions.
upvoted 0 times
...
Alfred
1 year ago
I hear you, it's a never-ending cycle of monitoring and maintenance to keep everything running smoothly.
upvoted 0 times
...
Mari
1 year ago
I agree, it's important to stay on top of updates and security patches for optimal performance.
upvoted 0 times
...
Lucille
1 year ago
I know, managing Azure VMs and SQL Servers can be quite challenging at times.
upvoted 0 times
...
Alyce
1 year ago
Managing Azure VMs and SQL Servers can be challenging at times.
upvoted 0 times
...
...
Sherman
1 year 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 year 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
1 year ago
Let's make sure to configure the necessary settings to ensure high availability for the Database.
upvoted 0 times
...
Rodolfo
1 year ago
That's a good idea. We can also set up SQL Server Always On Availability Groups for automatic failover.
upvoted 0 times
...
Oliva
1 year ago
We could use Azure Load Balancer to distribute traffic between the two SQL Server instances.
upvoted 0 times
...
Peggie
1 year 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
1 year 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 year ago
We could use Azure SQL Database Geo-Replication to replicate the database from DBServer1 to DBServer2.
upvoted 0 times
...
...
Gracia
1 year ago
I think the question in the exam might ask us to configure replication between DBServer1 and DBServer2 for Database.
upvoted 0 times
...
Maile
1 year 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
1 year 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
1 year ago
Yes, you can configure DNS to access the database on those VMs using the contoso.com domain.
upvoted 0 times
...
...
Teri
1 year ago
I have two Azure VMs, DBServer1 and DBServer2.
upvoted 0 times
...
Gracia
1 year ago
I have an Azure subscription with contoso.com domain.
upvoted 0 times
...

Save Cancel