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_Products that contains 60 lookup tables. The lookup tables should remain static at all times and users should not be able to alter the static data. You discover that some of the data in the lookup tables have been altered. You need to ensure that users cannot change any of the data in the lookup tables.
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. 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 named JobA that is run manually by Domain.com users in the Sales department. A month later you become concerned that Sales department users may neglect running JobA and want determine when JobA was last run.
What should you do? (Each correct answer presents a complete 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_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)