You are creating a Web-based application to manage data aggregation for reports. The application connects to a SQL Server 2005 database named DataManager. One page in the application has controls that execute stored procedures in a database named ReportingDatabase. There is an existing Service Broker connection between the DataManager database and ReportingDatabase.
You want to add two new message types to the existing service. In each database, you create message types named ProcessReport and SendResult. You need to add the two new message types to the existing service. What should you do first?

A power failure occurs on the storage area network (SAN) where your SQL Server 2005 database server is located.
You need to check the allocation as well as the structural and logical integrity of all databases, including their system catalogs. What should you do?

A support engineer reports that inserting new sales transactions in a SQL Server 2005 database results in an error. You investigate the error. You discover that in one of the databases, a developer has accidentally deleted some data in a table that is critical for transaction processing. The database uses the full recovery model. You need to restore the table.
You need to achieve this goal without affecting the availability of other data in the database. What should you do?

You are responsible for implementing maintenance jobs on a SQL Server 2005 database server. Certain jobs run every Sunday and other jobs run at the beginning of every month.
You need to schedule the jobs in the way that uses the least amount of administrative effort. What should you do?

TestKing.com uses SQL Server 2005. Users report that report execution is slow. You investigate and discover that some queries do not use optimal execution plans. You also notice that some optimizer statistics are missing and others are out of date.
You need to correct the problem so that reports execute more quickly. Which two Transact-SQL statements should you use? (Each correct answer presents part of the solution. Choose two.)

Domain.com as employed you as a database administrator. The Domain.com network consists of a single Active Directory domain named Domain.com. The Domain.com network contains a SQL Server 2005 database named Certkiller -DB06
Certkiller -DB06 consists of a trigger named trg_InsertOrders. The trigger fires when order data is inserted into the Orders table. The trigger ensures that a client exists in the Customers table prior to the information being inserted into the Orders table. You have received instruction from the CIO to configure the trigger to prevent it from firing during the information import process. You need to accomplish this using the minimum of administrative effort. Which Transact-SQL statements should you use? (Choose all that apply)

You work as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Domain.com uses a SQL Server 2005 database named Certkiller -DB01. Client information from the trading partners of Domain.com is imported into the CK_Clients table every night. You need to make certain that the client record is updated if it already exists in the CK_Clients table. However, if the record does not exist the information needs to be inserted into the CK_Clients table.
What should you do?

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 include administrating a SQL Server 2005 database named Certkiller -DB01. You have received instruction from the CIO to create a view to join the Clients and Products tables in Certkiller -DB01. You instruct him to make sure that the view cannot be affected by modifications to underlying table schemas. You need to accomplish this with the minimal amount of overhead.
What should Rory Allen do?