You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance. The SQL Server 2008 instance contains a database named ABC_Tester that is used by
the ABC.com’s developers. You need to allow the developers to access the SQL Server Profiler to
get traces which can be used to troubleshoot the application that ABC_Tester uses.
What action can you take to comply with this scenario?

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_DB1.
You have configured SQL Server log shipping for ABC_DB1 to occur every hour on the hour. You
then receive instructions to create a scheduled task to run a full backup of ABC_DB1 after
business hours.
Which of the following is TRUE with regards to this scenario?

You work as a SQL Server 2008 database administrator at ABC.com. One morning you have
received numerous complaints from the users at ABC.com that a database application is running
very sluggish. You need to check the disk, CPU, and memory utilization; information and still
consider the network.
What should you do?

You work as a database administrator at ABC.com. ABC.com makes use of a SQL Server 2008
R2 instance.
ABC.com has a database, named ABCSales, which has a primary filegroup that includes the OnLine Transaction Processing (OLTP) data. ABCSales also has another filegroup, named
ABCSalesHistory, which hosts antiquated records for the database. These two filegroups are
located on separate drives, while the transaction log for ABCSales is located on a different drive
altogether.
ABC.com’s business hours are from 8 Am to 5 PM. You have configured an archiving solution that
allows for the constant relocation of information from the primary filegroup to ABCSalesHistory.
You have also configured a backup solution that backs up the primary filegroup every 2 hours,
starting at 9 AM and ending at 5 PM. The backup solution includes a daily backup of the
ABCSalesHistory filegroup at 5 PM, and an hourly backup of the transaction log.
When the drive that hosts the ABCSalesHistory filegroup becomes corrupt during the day, you are
instructed to perform a restore procedure that allows for as little records as possible to be lost. The
speed of the restore procedure should also be as fast as possible.
You start by manually backing up the transaction log.
Which two of the following actions should you take NEXT? (Choose two.)

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance that contains a large database named ABC_DB1 that is only updated during working
hours. You have received instructions to create a backup and recovery plan that will ensure that
no data that is older than 1 hour is lost.
How should you configure your backup and recovery plan? (Choose all that apply)

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2005
instance that host a database named Products. You want to monitor query response times on the
Products database.
How would you accomplish this task?

You work as a SQL Server 2008 database administrator at ABC.com. ABC.com is using a SQL
instance that has a stored procedure which is used create a report. One day, a ABC.com user
named Mia Hamm complains that the data returned by the report lacks consistency. During the
investigation you notice that this is the results of phantom reads. You need to make sure that the
report resultsare consistent. Other database users at ABC.com must not be affected by your
solution.
How would you accomplish this task?

You work as a SQL Server 2008 database administrator at ABC.com. ABC.com is using a SQL
instance that contains a database named ABC_Prod. Recently ABC_Prod has frequently become
deadlocked. You have received instructions from management to have the database log
information when it becomes deadlocked.
How would you configure the ABC_Prod database? (Choose TWO)

You work as a database administrator at ABC.com. ABC.com makes use of a SQL Server 2008
R2 instance.
You have been instructed to gather information about current users, sessions, and processes for
the instance.
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
instance. The SQL Server 2008 instance hosts quite a few applications. ABC users report that one
of the applications has stopped working.
An application developer named Mia Hamm has been assigned to troubleshoot the application.
You need to provide Mia Hamm with only the permissions required for her to perform this task.
What steps should you take?