Microsoft-TS Microsoft SQL Server 2008 - Implementation and Maintenance Set 3

You maintain a SQL Server 2008 instance. You have an existing database maintenance plan that performs the following tasks: It checks database integrity. It rebuilds indexes. It writes a report to a text file. You need to modify the SQL Server instance such that an e-mail message is sent to the operators when the maintenance plan fails to execute successfully. What should you do?

You configure a SQL Server 2008 instance that contains a database named Customers. The Customers database experiences deadlock problems. You need to capture the deadlock information to the SQL Server error log. What should you do?

You maintain a SQL Server 2008 instance. You create a new SQL Agent job that includes a Windows PowerShell job step. The PowerShell job step uses the SQLCmd utility to transfer data between servers. You need to ensure that an operator named ResponseTeam is notified by an e-mail message if the job fails. What should you do?

You configure a SQL Server 2008 instance that contains a database named AdventureWorks. The AdventureWorks database experiences deadlock problems. You need to capture the deadlock information to the SQL Server error log. What should you do?

You administer a SQL Server 2008 instance. The server contains a very large database that is used by an application that is constantly available. Users report that the server performance has degraded. You need to use the Database Engine Tuning Advisor to improve the performance of the application. You also need to ensure that the performance of the production server is unaffected while analyzing the workload. What should you do?

You maintain a SQL Server 2008 instance. You find a SQL Server Agent job is failing. When you review the job history information, you notice that the job history information is incomplete and appears to be truncated. You need to ensure that all information produced by a job is available for viewing. What should you do?

You maintain a SQL Server 2008 instance that contains a database named DB1. DB1 stores customer data for the company. The customers use a Web application to access their profile data. You need to protect the customer data such that data files, log files, and subsequent backups are as secure as possible even if the backup media is lost. Your solution must not affect the Web application or impact performance. What should you do?

You maintain a SQL Server 2008 instance that contains a database named CustomerDB. The CustomerDB database stores customer data for the company. The customers use a Web application to access their profile data. You need to protect the customer data such that data files, log files, and subsequent backups are as secure as possible even if the backup media is lost. You want to achieve this goal without affecting the Web application. What should you do?

You administer a SQL Server 2008 instance that contains a database named DB1. DB1 contains a table named Table1. The DB1 database includes a stored procedure named Procedure1. Procedure1 uses a sp_executesql Transact-SQL statement to select data from Table1. According to business requirements, users are not allowed to access tables directly in any database. When a user executes Procedure1, the following exception is raised: "Msg 229, Level 14, State 5, Line 1 The SELECT permission was denied on the object 'Table1', database 'DB1', schema 'dbo'." You need to ensure that the user can successfully execute Procedure1 without violating the business requirements. What should you do?

You are the database administrator for a SQL Server 2008 computer named TESTDB. A user reports that his query has been running for a very long time and is still running.You access the sys.dm_tran_locks dynamic management view (DMV). The relevant results are shown in the following table.Which is the correct answer?