ExamGecko
Question list
Search
Search

Related questions

Question 82 - NCP-DB-6.5 discussion

Report
Export

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?

A.
2 Cluster VIP and 1 listener IP on the local site
Answers
A.
2 Cluster VIP and 1 listener IP on the local site
B.
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 1 Cluster VIP 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
Answers
B.
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 1 Cluster VIP 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
C.
I Cluster VIP end I Listener IP on the local site 1 Listener IP on the local site 2 IPs in the local site and I on the remote site for the database server nodes
Answers
C.
I Cluster VIP end I Listener IP on the local site 1 Listener IP on the local site 2 IPs in the local site and I on the remote site for the database server nodes
D.
Cluster VIP end I 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
Answers
D.
Cluster VIP end I 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
Suggested answer: D

Explanation:

The correct answer is D. 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 addresses:

1 Cluster VIP and 1 Listener IP on the local site123.

1 Cluster VIP and 1 Listener IP on the remote site123.

2 IPs in the local site and 1 on the remote site for the database server nodes123.

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 clients123.

asked 23/09/2024
Gufran Dalwai
46 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first