70-465 Question #146: Real Exam Question with Answer & Explanation

Submitted by helene.fr· Mar 5, 2026Implement High Availability and Disaster Recovery Solutions - specifically configuring SQL Server Always On Availability Groups including endpoint creation, AG definition, and secondary replica joining procedures.

Question

Drag and Drop Question The business requires a satellite office to have a local copy of the data to report against. You want to implement a solution to support the requirements. You need to establish a new Availability Group between the two servers. Develop the solution by selecting and arranging the required code blocks in the correct order. You may not need all of the code blocks. Answer:

Explanation

Setting up an Always On Availability Group requires a specific sequence of steps executed on both the primary (HQ) and secondary (Satellite) servers. First, a database mirroring endpoint must be created on each server to enable communication (CREATE ENDPOINT), then the Availability Group is created on the primary with replica definitions (CREATE AVAILABILITY GROUP), and finally the secondary server must join the Availability Group (ALTER AVAILABILITY GROUP ... JOIN). This ordered sequence ensures the transport layer is established before the AG is defined, and the secondary can only join after the AG exists on the primary.

Topics

#Always On Availability Groups#High Availability#SQL Server Endpoints#Database Replication

Community Discussion

No community discussion yet for this question.

Full 70-465 Practice Browse All 70-465 Questions