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?

A. Run the New SQL Server stand-alone installation Wizard on Node C.

B. Run the Add Node to SQL Server Failover Cluster Wizard on Node C.

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

D. Use Node A to insta

ll SQL Server on Node C.

Reference:

To add a node to an existing SQL Server failover cluster, you must run

SQL Server Setup on the node that is to be added to the SQL Server failover cluster instance. Do not run Setup on the active node.

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

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

You administer a Microsoft SQL Server 2012.

A process that normally runs in less than 10 seconds has be

en running for more than an hour.

You examine the application log and discover that the process is using session ID 60.

You need to find out whether the process is being blocked.

Which Transact-SQL statement should you use?

A. EXEC sp_who 60

B. SELECT

* FROM sys.dm_exec_sessions WHERE sessionid = 60

C. EXEC sp_helpdb 60

D. DBCC INPUTBUFFER (60)

References:

You administer a Microsoft SQL Server 2012.

A process that normally runs in less than 10 seconds has been running for more than an hour.

You examine the applicati

on log and discover that the process is using session ID 60.

You need to find out whether the process is being blocked.

Which Transact-SQL statement should you use?

A. SELECT * FROM sys.dm_exec_sessions WHERE session_id = 60

B. DBCC INPUTBUFFER (60)

C.

EXEC sp_helpdb 60

D. SELECT * FROM sys.dm_exec_request WHERE session_id = 60