nerdexam
Microsoft

70-457 · Question #157

You administer a Microsoft SQL Server 2012 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…

The correct answer is C. Run the Add Node to SQL Server Failover Cluster Wizard on Node C. See the full explanation below for the reasoning.

Question

You administer a Microsoft SQL Server 2012 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?

Options

  • ACreate a ConfigurationFile.ini file from Node B, and then run the AddNode command-line tool on Node A.
  • BUse Node A to install SQL Server on Node C.
  • CRun the Add Node to SQL Server Failover Cluster Wizard on Node C.
  • DUse Cluster Administrator to add a new Resource Group to Node B.

How the community answered

(40 responses)
  • A
    15% (6)
  • B
    5% (2)
  • C
    73% (29)
  • D
    8% (3)

Community Discussion

No community discussion yet for this question.

Full 70-457 Practice