Microsoft PRO:MS SQL Serv 08,Design,Optimize, and Maintain DB Admin Solu - 070-450 Exam Practice Test

You are a professional level SQL Sever 2008 Database Administrator.
The capacity planning information is required by your company. A long-term infrastructure monitoring strategy should be implemented.
Which two actions should be contained in the strategy? (Choose more than one)

You administer a SQL Server 2008 infrastructure. You plan to design an infrastructure for a new application.
The application has the following requirements:
Users can connect to an instance named SQLSERVER1.
SQLSERVER1 is linked to a server named SQLSERVER2.
SQLSERVER1 and SQLSERVER2 run on different computers.
The SQL Server instances use only Windows authentication.
You need to configure the infrastructure to ensure that the distributed queries are executed in the Windows security context of the login.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

You administer a SQL Server 2008 instance.
You plan to design a monitoring solution for the instance to monitor object usage statistics.
The solution must identify a list of first 10 objects for each of the following components:
Most frequently executed stored procedures and functions
Long running Transact-SQL statements
You need to implement the monitoring solution to minimize performance effect by using the least amount of administrative effort.
What should you do?

You are a professional level SQL Sever 2008 Database Administrator.
The solution is log-shipped for high-availability purposes. The data files of the database reside on drive D,
while the transaction log files of the database reside on drive E. A restoring test plan should be
implemented
to satisfy the requirements listed below for the log-shipping solution.
First, the secondary database is brought online in the shortest time.
Secondly, the data is in a consistent state.
Thirdly, the data loss is reduced to the least.
The first step for the recovery test plan should be identified in the event of drive D failure.
Which step should be performed?

You administer a SQL Server 2008 infrastructure . You design a corporate backup and recovery strategy that has to be validated.
You need to ensure the successful recovery of any single database from a catastrophic failure without requiring a backup data center in a different location.
Which three tasks should you include? (Each correct answer presents part of the solution. Choose three.)

You administer a SQL Server 2008 instance.
Customers report server performance degradation because of a newly implemented process. You use Dynamic Management Views to verify that there are no long running queries.
You need to correlate the operating system performance data with the actual query execution trace by using minimum administrative effort.
What should you do?