You are a database administrator for AIOTestKing.com. You are configuring a new SQL Server 2005 computer. The computer contains five hard disks. You need to ensure that the server can continue functioning in the event that a single hard disk fails. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

You are a database administrator for AIOTestKing.com. The company uses a SQL Server 2005 application. Users report that the application sometimes responds very slowly for several minutes at a time. This problem occurs throughout the day and typically takes place after a large number of database rows are deleted. The database properties are configured as shown in the exhibit. (Click the Exhibit button.)

You need to ensure that this performance problem does not recur. What should you do?

You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer named AIOTestKingA. You create a security template that disables unnecessary services. The template is appropriate only for AIOTestKingA. You need to ensure that the security template is applied to AIOTestKingA. Your solution must ensure that the template automatically overrides any manual configuration changes made by other administrators within an hour. What should you do?

You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer named AIOTestKing B. AIOTestKing B runs a single SQL Server instance. You manage AIOTestKing B from an administrative workstation named DBA1. AIOTestKing B intermittently fails to respond to user queries. Currently, it is not responding to your connection through SQL Server Management Studio. You need to correct the problem. What should you do?

You are a database administrator for AIOTestKing.com. You are responsible for 20 SQL Server 2005 computers. These computers are monitored by other administrators who are required to ensure that query response times meet company service level agreements (SLAs). You need to provide these administrators with a consistent way of monitoring query response times on the servers. What should you do?

You are a database administrator for AIOTestKing.com The company uses a SQL Server 2005 database that contains a table named Production.Product. There are more than 40 columns in the table. The most common queries are shown in the following Transact-SQL statements.
–QUERY 1 SELECT [Name], [ProductLine], [ListPrice], [Class], [Style] FROM [Production].[Product] WHERE [ProductLine] = ‘T’
–QUERY 2 SELECT * FROM [Production].[Product] ORDER BY [Name]
You need to choose the best indexes to support the most common queries to the Production.Product table while minimizing the space required for the indexes. Which two indexes should you use? (Each correct answer presents part of the solution. Choose two.)

You are a database administrator for AIOTestKing.com. You run SQL Server Profiler by using the SP:Recompile event class. You notice a large number of recompiles occurring.
You need to identify the possible cause of the large number of recompiles. What is the most likely cause of the problem?

You are a database administrator for AIOTestKing.com. The company uses a SQL Server 2005 computer that runs Reporting Services. Reporting Services is used to produce hundreds of reports each day. You discover that the ReportServerTempDB database is growing. You need to minimize the size of the ReportServerTempDB database. What should you do?

You are a database administrator for AIOTestKing.com. Your company has 10 SQL Server 2005 computers in a distributed environment. The SQL Server computers each subscribe to a transactional replication publication. Company policy defines service level agreements (SLAs) for maximum replication latency. You need to verify that the SLAs are being met. What should you do?

You are the database administrator of a SQL Server 2005 computer named AIOTestKing A.
The following query is run frequently.

All tables referenced in the query are read-intensive with very few inserts and updates.
You cannot change existing objects in the database. You can add new objects to the database. You need to optimize the performance of the query. What should you do?