ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-300 All Questions

View all questions & answers for the DP-300 exam
Go to Exam

Exam DP-300 topic 6 question 15 discussion

Actual exam question from Microsoft's DP-300
Question #: 15
Topic #: 6
[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 DatabaseA. 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.
  • 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.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by o2091 at Nov. 5, 2021, 12:46 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
bingomutant
6 months, 3 weeks ago
C - Endpoint Configuration: Availability groups use port 5022 by default for the database mirroring endpoint, which is used for communication between the primary and secondary replicas. Therefore, both DBServer1 and DBServer2 should be configured to use TCP://DBServer1.contoso.com:5022 and TCP://DBServer2.contoso.com:5022 for their respective endpoints. Asynchronous Replication: The question specifies that DBServer1 has a high volume of data changes and low latency requirements for data writes. When replicas are geographically distributed across regions (like East US and West US in this case), using Synchronous replication can introduce significant latency because it waits for confirmation from the secondary replica before committing transactions.
upvoted 1 times
...
vcloudpmp
1 year, 9 months ago
https://hub.packtpub.com/firewall-ports-you-need-to-open-for-availability-groups-from-blog-posts-sqlservercentral/ 445 is for the WSFC fileshare witness.
upvoted 1 times
...
vcloudpmp
1 year, 10 months ago
https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/availability-group-overview?view=azuresql-vm - It appears that distributed AG describes a use case with replicas in multiple regions (vs. multiple availability sets or availability zones).
upvoted 1 times
...
vcloudpmp
1 year, 10 months ago
5502 applies to distributed AGs. This use case seems to be a single AG for database A.
upvoted 2 times
...
eric0718
3 years ago
Selected Answer: C
Asynchronous is low latency
upvoted 3 times
...
reachmymind
3 years, 1 month ago
The answer is correct, low latency = asynchronous TCP port = 5022 https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/configure-distributed-availability-groups?view=sql-server-ver15&tabs=automatic
upvoted 3 times
...
o2091
3 years, 6 months ago
looks good, what do you think?
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago