You administer a SQL Server 2008 instance.
You need to find out the number of users who access the SQL Server instance by using
Windows System Monitor.
Which performance object should you capture?

You administer a SQL Server 2008 instance. The instance contains databases for a finance
application and a manufacturing application. You configure the Resource Governor to limit
the maximum CPU query time allowed by the applications. The administrator of the
manufacturing application reports that certain reports no longer execute successfully. You
need to modify the Resource Governor configuration to allow the manufacturing application
to consume more CPU time.
Which Resource Governor component should you configure?

You troubleshoot the performance of a SQL Server 2008 instance.
You need to identify the longest-running common language runtime (CLR) queries.
Which dynamic management view should you use?

You are mastering the company database; a new SQL Server 2008 computer named
TesterDB should be set by yourself. Reporting Services will work in TesterDB. It should be

set to run database backups and other maintenance job automatically. In the network
environment, the company has no other SQL Server computers. The whole approach SQL2
will be made by using SQL1s DNS name. You should enable any necessary devices on
SQL2. Which is the correct answer?(select more than one)

You are mastering the company database called Testing; you should back up the Testing
database fully. You do transaction log once every two hours from 08:00 to 17:00.You should
run database snapshots for the Testing database. You should develop database snapshot
every day at 07:00. At 8:30 the user removes the whole information on the Testing database
which was entered intothe CurrentSpeaker table yesterday. Deletion is the first step for the
database. It is now 11:45 and many other changes have happened in the database. You
should find solution to solve this problem .Which is the correct answer?

You migrate an application from Microsoft SQL Server 2000 to Microsoft SQL Server 2008.
You need to monitor the SQL Server instance to record the use of features that will be
discontinued.
What should you do?

You administer a remote SQL Server 2008 instance. Users report that the performance of
the application is poor.
You use SQL Profiler to capture a workload of the remote instance to a trace table on the
remote SQL Server instance.
You need to analyze the workload of the remote SQL Server instance on a local SQL Server
instance by using the Database Engine Tuning Advisor.
What should you do?

You manage a SQL Server 2008 instance. You plan to maintain a management data
warehouse that collects performance data by using the data collector.
You need to implement a process that routinely gathers and uploads data in the
management data warehouse on different schedules.
What data collection process should you implement?

You maintain a SQL Server 2008 instance. Your failure recovery plan requires you to back
up the default trace.
You need to backup the subdirectory that contains the default trace.
Which SQL Server database engine subdirectory should you back up?

You are mastering the company database, you should check the log of the SQL Server 2008
Enterprise Edition everyday, and you get the information on the torn page errors of the
database. In order to fine the solution of the torn page, which is the correct answer?