NCP-DB-6.10 · Question #102
An administrator needs to provision a 3-node MSSQL Server AG with the following configuration: - Two database server VMS including the primary replica on a local site - A third database server VM on…
The correct answer is D. 1 Cluster VIP end I Listener IP on the local site. When setting up a 3-node MSSQL Server AG with two database server VMs on a local site and a third database server VM on a remote site, the network at each site will require the following IP 1 Cluster VIP and 1 Listener IP on the local site. 1 Cluster VIP and 1 Listener IP on…
Question
An administrator needs to provision a 3-node MSSQL Server AG with the following configuration:
- Two database server VMS including the primary replica on a local site
- A third database server VM on a remote site
How many IP addresses will the network at each site require?
Options
- A2 Cluster VIP and 1 listener IP on the local site
- B1 Cluster VIP and 1 listener IP on the remote site
- C1 Cluster VIP end I Listener IP on the local site
- D1 Cluster VIP end I Listener IP on the local site
How the community answered
(15 responses)- B13% (2)
- C7% (1)
- D80% (12)
Explanation
When setting up a 3-node MSSQL Server AG with two database server VMs on a local site and a third database server VM on a remote site, the network at each site will require the following IP 1 Cluster VIP and 1 Listener IP on the local site. 1 Cluster VIP and 1 Listener IP on the remote site. 2 IPs in the local site and 1 on the remote site for the database server nodes. This configuration ensures that each node in the cluster has a unique IP address, and each cluster and listener also has a unique IP address. This is necessary for the proper functioning of the cluster and to ensure that all nodes can communicate with each other and with clients.
Topics
Community Discussion
No community discussion yet for this question.