Microsoft
DP-300 · Question #170
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…
The correct answer is C. Configure the primary endpoint as TCP://DBServer1.contoso.com:5022, configure the secondary. Use TCP port 5022, and use asynchronous mode for low latency. https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/availability- modes-always-on-availability-groups?view=sql-server-ver15
Submitted by jordan8· Mar 6, 2026Plan and configure a high availability and disaster recovery (HA/DR) environment
Question
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?
Options
- AConfigure the primary endpoint as TCP://DBServer1.contoso.com:445, configure the secondary
- BConfigure the primary endpoint as TCP://DBServer1.contoso.com:445, configure the secondary
- CConfigure the primary endpoint as TCP://DBServer1.contoso.com:5022, configure the secondary
- DConfigure the primary endpoint as TCP://DBServer1.contoso.com:5022, configure the secondary
How the community answered
(29 responses)- A31% (9)
- B7% (2)
- C48% (14)
- D14% (4)
Explanation
Use TCP port 5022, and use asynchronous mode for low latency. https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/availability- modes-always-on-availability-groups?view=sql-server-ver15
Community Discussion
No community discussion yet for this question.