You are a database administrator for AIOTestKing.com. You manage a database named Invoicing. The Invoicing database is backed up with a full backup nightly and transaction log backups once every two hours from 08:00 to 17:00. You implement database snapshots for the Invoicing database. A database snapshot is created each day at 07:00.

At 09:30 today, a user inadvertently deleted all of the invoices that were entered into the CurrentInvoice table yesterday. None of these invoices had been changed today prior to the deletion. It is now 11:45 and many other changes have occurred in the database. You need to recover the lost rows with as few administrative steps as possible while minimizing data loss. What should you do?

You are a database administrator for AIOTestKing.com. The SQL 2005 Server computer has been in operation for more than one month. This past week, query performance problems have led you to investigate locking contention. The sys.dm_os_wait_stats dynamic management view (DMV) is showing a high value in the max_wait_time_ms column.
You need to find out if this value is a factor in the current performance problems. You also must minimize the impact on database users. What should you do?

You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer named AIOTestKing A. AIOTestKing A replicates with other SQL Server computers and manages multiserver automation jobs. It also exports data to staging databases for export to a data warehouse. After a few months without incident, AIOTestKing A fails to start after a reboot.
You review the security log, which returns the results that the Security Log Results exhibit shows.

You then review an individual audit entry, which the Individual Audit Entry exhibit shows.

The Default Domain Group Policy object (GPO) is configured with a Password Policy and Account Lockout Policy as shown in the following table.

You need to ensure that AIOTestKing A runs properly. What should you do?

You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer named AIOTestKing A. AIOTestKing A is configured to automatically perform transaction log backups, database integrity checks, and other maintenance tasks on a regular basis. Another administrator uses the SQL Server Surface Area Configuration tool to reconfigure AIOTestKing A. You notice that AIOTestKing A no longer performs the automated maintenance tasks. You need to ensure that the maintenance tasks on AIOTestKing A are completed automatically. What should you do?

You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer named AIOTestKing A. AIOTestKing A is a member of a Microsoft Active Directory domain. You do not have any rights or privileges to perform domain administration. However, you have been granted membership in the local Administrators group on AIOTestKing A. You perform most of the management of AIOTestKing A from your administrative workstation. However, for security reasons, you want to track all attempts for interactive logons and network connections to AIOTestKing A. What should you do?

You are a database administrator for AIOTestKing.com. You are configuring a new SQL Server 2005 computer named AIOTestKing A. AIOTestKing A will run Reporting Services. It will also be configured to automatically perform database backups and other maintenance tasks. There are no other SQL Server computers in the network environment. All access to AIOTestKing A will be made by using AIOTestKing As DNS name. You need to disable any unnecessary services on AIOTestKing A.
Which service or services should you disable? (Choose all that apply.)

You are a database administrator for AIOTestKing.com. You receive alerts reporting that several transactions on your SQL Server 2005 database have terminated due to a deadlock error. You need to find out the causes of the deadlocks. What should you do?

You are a database administrator for AIOTestKing.com. A user named AIOTestKing belongs to the Windows SalesManagers group. AIOTestKing needs a Reporting Services report to display annual sales information by territory. A user named Joe reports to AIOTestKing and belongs to the Windows Sales group. He needs a report that is limited to his sales territory, but still displays the same detailed sales data that is on AIOTestKing’s report. You need to design a secure solution that meets the reporting needs of the users and that consumes the minimal amount of server resources. What should you do?

You are a database administrator for AIOTestKing.com. Your SQL Server 2005 database contains a table named Customer with a column named PostalCode in it. New PostalCode values are added regularly. You need to ensure that values contained in the PostalCode column are verified. You need to retrieve, from the Postal Service in each country in which you have customers, the domain of values for the PostalCode column.
Rapid response time for data access is of primary concern. What should you do?

You are a database administrator for AIOTestKing.com. A software developer in the company is running the following query against a SQL Server 2005 database. SELECT Surname FROM Employees WHERE UPPER(Surname) LIKE ‘COR%’ The software developer reports that the query runs quickly on a test database that has a small number of rows. However, the query runs very slowly on the production database that has millions of rows. The Surname column stores data in mixed case, by using case-sensitive collation. But the query needs to perform a case-insensitive search. You need to improve the performance of this query. However, you do not have permission to change the collation orders. And you cannot modify the application code that adds rows to the database. Which three actions should you perform? (Each correct answer presents part of the solution. Choose three.)