You work as a database administrator at ABC.com. ABC.com has a database named ABC_DB.
ABC_DB has a table named ABC_Prod that has over 100,000 rows. Several indexes that have
been created on the ABC_Prod tableare fragmented.
How would you deframent the indexes without causing too much unavailability of the table?

You work as a database administrator at ABC.com. You want to know how many users are
connected to a SQL Server 2008 instance.
What steps should you take?

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?