You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008 R2
instance that includes an acquiring database and a selling database.
After setting the Resource Governor up to reduce the maximum CPU search time permitted for the
applications, you notice that some of the reports of the acquiring application does not execute
successfully.
You need to ensure that the Resource Governor settings are suitably altered to permit more CPU
time for the acquiring application.
Which of the following actions should you take?

You work as a database administrator at ABC.com.ABC.com is using a SQL Server 2008 R2
instance.
You been instructed to query the sys.dm_exec_query_stats view.

Which of the following options describes a reason for querying this view? (Choose all that apply.)

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008 R2
instance that contains a database named ABC_Prod.
The transaction log for ABC_Prod runs from 7 AM to 4 PM at 1 hour intervals. You have
configured a snapshot of the database to be taken daily at 6 AM.
A ABC.com user, named Mia Hamm, starts her day everyday by removing all ABC_Prod data that
was entered into the ExistingSpeaker table the previous day. Numerous other changes have since
been made to ABC_Prod.
You have received instructions to run a full back up on ABC_Prod despite all these problems.
Which of the following actions should you take?

You work as a database administrator at ABC.com. ABC.com is using a remote instance of SQL
Server 2008 R2.

Subsequent to receiving complaints that applications are running sluggishly, you decide to make
use of the Database Engine Tuning Advisor to examine a workload of the remote SQL Server
2008 R2 instance on a local SQL Server 2008 R2 instance.
Which of the following actions should you take?

You work as a database administrator at ABC.com. ABC.com is making use of a SQL Server 2008
R2 instance.
You have been given the responsibility of administering a management data warehouse that will
store performance information. You want to configure a data collector that has the ability to collect
performance information regularly on a defined schedule, and upload the collect performance
information on a separate schedule.
Which of the following actions should you take?

You work as a database administrator at ABC.com.ABC.com is making use of a SQL Server 2008
R2 instance.

The SQL Server 2008 R2 instance contains a database named ABC_DB. ABC_DB stores its data
file and transaction log file on a storage drive.
When it is reported that the storage drive is reaching capacity, you are instructed to relocate the
data file and transaction log file to a different storage drive.
Which of the following actions should you take?

You work as a SQL Server 2008 database administrator at ABC.com. ABC.com is currently using
only the default SQL instance on their database server. You plan to implement several named
instances on the database server.
Which of the following actions should you take to ensure that you can access the named
instances?

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance. You want to check when last DBCC CHECKDB was run on a database.
What actions should you take?

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
database server with a default instance. During routine maintenance you notice that a query
against a database is taking long to complete.
How would you check to see if the query is being blocked?

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008 R2
instance.
You have previously configured a weekly full backup, and a daily differential backup for the
database. You want to that the most recent data is available, even if the database server fails
during the work day. You also want to make sure that data loss is kept to a minimum.
Which of the following actions should you take?