You work as the database administrator at Domain.com. All servers on the Domain.com network run Windows Server 2003 and all database servers run SQL Server 2005. The Domain.com network contains a database server named Certkiller -DB01 B01. Certkiller -DB01 hosts a database named CK_Sales that stores sales data for the company.
You create a maintenance job that runs two statements against the CK_Sales database and schedule the job to run every evening at 7:30 P.M. The following morning you confirm that the job ran on schedule. A month later you discover that the job has failed and no longer runs on schedule. You need to determine the cause of the problem.
What should you do?

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 at Domain.com include the administration of the SQL Server computer named Certkiller -DB03. Certkiller -DB03 was installed using default settings. A Domain.com employee named Clive Wilson is appointed as the junior technician in the Research and Development department. A power failure occurs. You detect that the SQL Server (MSSQLSERVER) service on your database server does not start. You instruct Clive Wilson to troubleshoot the error. What actions should Clive Wilson perform? (Choose all that apply)

You work as the database administrator at Domain.com. All servers on the Domain.com network run Windows Server 2003 and all database servers run SQL Server 2005. Domain.com has its headquarters in Chicago and branch offices in Dallas and Miami. You work in the Miami office. Head office contains a database server named Certkiller -DB01 B01. Certkiller -DB01 hosts a database named CK_Sales that stores sales data for the company.
Several Domain.com users in the Miami office start complaining about difficulty in connecting to the CK_Sales database. You discover that connection between the clients and Certkiller -DB01 is being terminated. You need to determine the cause of the network connectivity problem as quickly as possible. Unfortunately, the administrator at the Chicago office is on sick leave and you are unable to travel to the Chicago office. You need to access Certkiller -DB01 from your administrative computer.
What should you do?

You work as the database administrator at Domain.com. All servers on the Domain.com network run Windows Server 2003 and all database servers run SQL Server 2005 with the default settings. The Domain.com network contains a database server named Certkiller -DB01 that hosts a database named CK_Sales. The CK_Sales database stores sales data for the company. One morning Domain.com users complain that they are unable to connect to Certkiller -DB01. You log on to your client computer named Certkiller -WS444. You attempt to connect to Certkiller -DB01 using the Dedicated Administrator Connection (DAC) but the connection fails. You need to be able to connect to Certkiller -DB01 from Certkiller -WS444.
What should you do? (Each correct answer presents part of the solution. Choose two.)

You work as the database administrator at Domain.com. All servers on the Domain.com network run Windows Server 2003 and all database servers run SQL Server 2005. The Domain.com network contains a database server named Certkiller -DB01 B01. Certkiller -DB01 hosts a database named CK_Manufacturing that stores data from the Manufacturing department. One day Domain.com users complain that they cannot access the CK_Manufacturing database on Certkiller -DB01. When you attempt to open the SQL Server management Studio, you discover that Certkiller -DB01 is not responding. You are unable to connect using sqlcmd with a standard connection. You need to be able to connect to Certkiller -DB01 to be able to diagnose the problem.
What should you do?

You work as the database administrator at Domain.com. All servers on the Domain.com network run Windows Server 2003 and all database servers run SQL Server 2005. Six month after implementing a Web application that access a Domain.com database; Web site users complain about poor response times from the Web site. You need to determine if the problem is caused by deadlocks. If the problem is caused by deadlocks, you want to determine which objects are involved in the deadlocks.
What should you do?

You are employed as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. The Domain.com network makes use of a SQL Server 2005 database. You have been informed by the CIO that a user reported that an order processing application stopped responding during a transaction. You investigate and detect that the user’s session is being blocked by an errant process. The user’s session is session ID 85. The session ID of the errant process is 101. You are required to solve this error as quick as possible in order for the user to carry on using the application without losing any work.
What should you do to accomplish this objective? (Choose all that apply)

You work as the database administrator at Domain.com. All servers on the Domain.com network run Windows Server 2003 and all database servers run SQL Server 2005. The Domain.com network contains a database server named Certkiller -DB01 B01. Certkiller -DB01 hosts a database named CK_Sales that stores sales data for the company.
Domain.com recently acquired another company named Testlabs.com. Users in TestLabs.com also access the CK_Sales database on Certkiller -DB01. A Domain.com user reports that she often receives an error message when she accesses the CK_Sales database. You discover that an errant process is causing the error message. You need to terminate the errant process while minimizing the impact on users that are currently connected to the database. You identify the session ID (SPID) of the errant process as SPID 34.
What should you do next?

You work as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. The Domain.com network contains a SQL Server 2005 database server named Certkiller -DB01.
Certkiller -DB01 contains a database named CK_Sales that is used to process sales orders via an order processing application. You received a report from a Domain.com user named Rory Allen informing you that the order processing application stopped responding in the middle of an order transaction. Rory Allen’s SQL Server session ID is 54.
You need to determine if session 54 is blocked by another connection. If the result is positive, you need to find the blocking session ID. What should you do? (Each correct answer presents a complete solution. Choose TWO.)

You work as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Your duties at Domain.com are the administrating of the SQL Server computers. The Domain.com network contains a SQL Server 2005 database server named Certkiller -DB01. Certkiller -DB01 contains a table that contains of quite a few indexes. During routine monitoring you notice that data modification performance has degraded. You also believe that some of the indexes are not used. You want to identify which indexes have not been used by any queries since the last time Certkiller -DB01 has started
What should you do?