PrepAway - Latest Free Exam Questions & Answers

You administer a Microsoft SQL Server 2016 failover cluster that contains two nodes named Node A and Node B.

You administer a Microsoft

SQL Server 2016 failover cluster that contains two nodes named Node A and Node B.

A single instance of SQL Server is installed on the cluster.

An additional node named Node C has been added to the existing cluster.

You need to ensure that the SQL

Server instance can use all nodes of the cluster.

What should you do?

A. Create a ConfigurationFile.ini file from Node B, and then run the AddNode command-line tool on Node A.

B. Use Node A to install SQL Server on Node C.

C. Run the Add Node to SQL Serv

er Failover Cluster Wizard on Node C.

D. Use Cluster Administrator to add a new Resource Group to Node B.

Explanation:

To add a node to an existing SQL Server failover cluster

Insert the SQL Server installation media, and from the root folder, d

ouble-click Setup.exe. To install from a network share, navigate to the root folder on the share, and then double-click Setup.exe.

The Installation Wizard will launch the SQL Server Installation Center. To add a node to an existing failover cluster instan

ce, click Installation in the left-hand pane. Then, select Add node to a SQL Server failover cluster.

Etc.

References: https://docs.microsoft.com/en-us/sql/sql-server/failover-clusters/install/add-or-remove-nodes-in-a-sql-server-failover-cluster-setup

Q


Leave a Reply