AZ-801 Question #17: Real Exam Question with Answer & Explanation

This simulation question tests knowledge of the prerequisite steps required to configure and enable replication on a SQL Server failover cluster (Cluster2), focusing on the correct ordered sequence of infrastructure and SQL Server setup tasks.

Implement and manage Windows Server high availability

Question

You need to meet the technical requirements for Cluster2. Which four actions should you perform in sequence before you can enable replication? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Explanation

Approach. Before enabling replication on a clustered SQL Server instance, you must complete foundational steps in order: (1) Verify or configure the Windows Server Failover Cluster (WSFC) is operational and Cluster2 nodes are joined, (2) Ensure SQL Server is installed on all cluster nodes with the same collation and service accounts, (3) Configure and enable the SQL Server Agent service on the cluster (required for replication agents to run), and (4) Configure a Distributor - either local or remote - and set up the distribution database, since the Distributor is a prerequisite that must exist before any Publisher or Subscriber roles can be created. Only after these four steps can replication be enabled and publications/subscriptions defined.

Concept tested. SQL Server replication prerequisites on a Windows Server Failover Cluster (WSFC) - specifically the ordered dependency chain: cluster health → SQL Server installation → SQL Server Agent configuration → Distributor/distribution database setup - before replication topology (Publisher/Subscriber) can be enabled.

Reference. Microsoft Docs: 'Configure SQL Server Replication on Always On Availability Groups' and 'Replication, Change Tracking, Change Data Capture, and Always On Availability Groups (SQL Server)' - docs.microsoft.com/sql/database-engine/availability-groups/windows/replicate-track-change-data-capture-always-on-availability

Topics

#Failover Clustering#Storage Replica#High Availability#Windows Server Replication

Community Discussion

No community discussion yet for this question.

Full AZ-801 Practice Browse All AZ-801 Questions