You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer named AIOTestKing A. All company servers run Windows Server 2003 and are part of an Active Directory domain. Company policy states that all servers are shut down each night. A SQL Server Agent backup job is configured to run on AIOTestKing A each morning at 09:00.
On the mornings when AIOTestKing A has not been turned on by 09:00, the job fails to start, and you must manually start it. You need to ensure that AIOTestKing A is backed up automatically each morning. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

You are the database administrator for AIOTestKing.com. The company uses a SQL Server 2005 database to track online sales. Employees who run the In-Stock report experience slow performance. This performance problem is caused by the contention between the In-Stock report and high volume of data entry to the tables that are accessed in this report. The company wants the In-Stock report returned immediately even though other employees might be changing the data within their data-entry transactions. Any changes made in other transactions while the report is running must be visible to the employees who are running the In-Stock report. You need to design a solution to achieve this goal.
What should you do?

You are a database administrator for AIOTestKing.com. You create a maintenance plan that includes shrinking your SQL Server 2005 databases and reorganizing your indexes once a week. You test the plan and discover that the database does not shrink as expected. You need to troubleshoot why the database is not shrinking. What are two possible ways to achieve this goal? (Each correct answer presents a complete solution. Choose two.)

You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer named AIOTestKingA. AIOTestKing A hosts a database named DB1. DB1 serves as the backend database for an application that tracks issues that help desk technicians receive and the associated trouble tickets. When installed, the help desk application loaded several stored procedures and views that are used for data manipulation and reporting purposes. DB1 contains more than 50 tables. The bulk of the data is stored within the Employees, Issues, Assets, and AssetTracker tables. An application developer inadvertently deletes the AssetTracker table in DB1. The AssetTracker table is referenced by several views and functions in the database. You need to ensure that users are not able to remove critical tables such as this that are referenced by views or functions. What should you do?

You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer. Your company’s database auditing department must receive an e-mail message when the SQL Server service and the SQL Server Agent service are started, stopped, or paused. They also need to receive an e-mail message when the EXECUTE AS option is used with stored procedures and other commands. You need to ensure that the auditing department receives the e-mail messages that they need. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

You are a database administrator for AIOTestKing.com. A database named OLTP_Report makes data available to Reporting Services reports. You use Reporting Services to create a report named SalesDeviation, which displays sales goals and sales representatives’ actual sales. You need to manage report subscriptions. All sales representatives located in the Windows Sales group who do not meet sales goals must automatically receive a SalesDeviation report every Monday morning. What should you do?

You are the database administrator of a SQL Server 2005 computer running SQL Server 2005 Enterprise Edition. You support a database named OnlineSales. This database exists on the following three filegroups. The primary filegroupFG1, a read/write filegroup FG2, a read/only filegroup with historical data. The database is set to the Full Recovery model.
You discover that a file from FG1 has been corrupted. FG1 is offline. All other filegroups are online. You need to restore FG1 while minimizing the time when no data is available.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

You are an administrator of 12 SQL Server 2005 computers. Users report that one of the SQL Server computers named AIOTestKing F is unavailable for almost an hour starting at 16:00. One of the other SQL Server administrators reports that during this time, he performed a quick routine maintenance task that included a restart. You view the SQL Server logs on AIOTestKing F for the time period in question, as shown in the exhibit.

You need to ensure that this unavailability does not happen again. What should you do?

You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer named AIOTestKing A. The master database on AIOTestKing A becomes corrupted. AIOTestKing A contains several SQL Server Agent jobs. All databases are backed up regularly. You rebuild and restore the master database. You need to ensure that AIOTestKing A functions as it did before the database failure. What should you do?

You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer named AIOTestKing A. Every Sunday, AIOTestKing A executes a job that performs a full backup of a database named HR. Each weeknight, AIOTestKing A executes a job that performs differential backups. All jobs have the option enabled to verify data in the backup. The HR database is often not able to be restored after a failure, because of errors with the data stored on the tape. You need to design a restore process that ensures that as much data as possible is restored, even when errors occur. What should you do?