You are employed as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Your duties include administrating a SQL Server 2005 database server named Certkiller -DB01. Certkiller -DB01 is configured for SQL Server and Windows Authentication mode.
You make use of Windows Authentication; therefore you have sysadmin privileges on Certkiller -DB01. You have received several reports from clients who work with Certkiller -DB01 stating that all applications that use Certkiller -DB01 stopped responding. You have received instruction from the CIO to investigate this error.
You check in Task Manager and detects that the CPU usage is at 100 percent. You attempt to connect to Certkiller -DB01 by using SQL Server Management Studio. However, Certkiller -DB01 does not respond. You are required to connect to Certkiller -DB01 to detect the problem.
How can you achieve this goal? (Choose all that apply)
A.
You need to connect to Certkiller -DB01 by using the sqlcmd command-line utility using a dedicated administrator connection.
B.
You need to connect to Certkiller -DBO1 by using the osql command-line utility.
C.
You need to click the Database Engine Query to open the Connect to Database dialog box in SQL Server Management Studio on the toolbar.
Thereafter you should type ADMIN: Certkiller -DB01 in the Server name text box.
The SQL Server Authentication selected and your sa credentials provided and the Connect button should then be clicked.
D.
You need to connect to Certkiller -DB01 by using SQL Server Management Studio.
Thereafter you should open a query window and perform the DBCC TRACEON 1224 command
Explanation:
The DAC is implemented as a specific TCP endpoint in a SQL Server instance that is always attached to a dedicated UMS. The DAC was created to provide a connection that could always be used by a member of the sysadmin role to access a SQL Server instance, thereby guaranteeing that an administrator could not be locked out of SQL Server due to resource allocation issues. You can connect to the DAC in two ways:
1. Via SQLCMD or
2. Through the query window in SSMS.