nerdexam
Microsoft

70-457 · Question #122

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

  • ARun the New SQL Server stand-alone installation Wizard on Node C.
  • BRun the Add Node to SQL Server Failover Cluster Wizard on Node C.
  • CUse Node B to install SQL Server on Node C.
  • DUse Node A to install SQL Server on Node C.

How the community answered

(29 responses)
  • A
    3% (1)
  • B
    79% (23)
  • C
    7% (2)
  • D
    10% (3)

Community Discussion

No community discussion yet for this question.

Full 70-457 Practice