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.
ABC.com also contains an application that makes use of the SELECT command to initiate the
process of populating various tables simultaneously. This application also makes use of
ABC_DB1.
When you receive several complaints from ABC.com’s users that the application is performing
very sluggish, you decide to keep an eye on the status of the SQL Server 2008 R2 instance. You
want to make sure that application performance is not influenced by your actions.
Which of the following actions should you take?

You work as a database administrator at ABC.com. ABC.com is making use of SQL Server 2008
R2.
You have just installed SQL Server Management Studio (SSMS) on one of ABC.com’s
workstations. You have not, however, included the Business Intelligence Development Studio
(BIDS) in the installation.
You are then instructed to design a transactional package that has the ability to accommodate
using in excess of 8 tables, and is hosted by the msdb database of a server that is located in a
different location.
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 for a Server Agent job.
During routine monitoring, you notice that the Server Agent job is not running as it should be.
Upon further analysis of the job history data, you find that it is unfinished and condensed.
You have to make sure that job data is accessible in its entirety.
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 instance includes a database named ABC_DB, which also contains spatial
data types. You have received instructions to run a database consistency check on ABC_DB. The
process should allow for the inclusion of the spatial indexes, while also reducing the impact on the
database synchronization.
You are planning to make use of the DBCC CHECKDB Transact-SQL statement.

Which of the following arguments should be included in the Transact-SQL statement?

You work as a database administrator at ABC.com. ABC.com is making us of a SQL Server 2008
R2 instance, which includes a database that hosts transaction data for ABC.com’s Web-based
order system.
The full recovery model is used on the database. The Web-based order system is utilized 24/7.
However, there are not many orders placed between 11 PM and 5 AM.
You have been instructed to devise a backup strategy that allows for the backup process to
complete in the least amount of time, while keeping the acceptable data loss to 60 minutes.
You have configured a full backup to run at 11 PM on a daily basis.
Which of the following actions should you take NEXT?

You work as a database administrator at ABC.com. ABC.com has recently upgraded from SQL
Server 2000 to SQL Server 2008 R2.
A database, named ABCClients, was detached prior to the upgrade. ABCClients is made up of 12

data files. You have been instructed to make sure that ABCClients is usable on the SQL Server
2008 R2 instance.
Which of the following actions should you take?

You work as a database administrator at ABC.com. You are working on a SQL Server 2008 R2
database called TestDB.
You have recently restored TestDB via a RESTORE Transact-SQL statement that includes the
CONTINUE_AFTER_ERROR, CHECKSUM, and RECOVERY arguments. You then noticed that
errors exist in the SQL Server logs for certain page restores.
You have received instructions to solve the issues as soon as possible.
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. The SQL Server 2008 instance contains a database, named ABC_Prod, which is
configured in single-user mode. You have configured a backup strategy for ABC_Prod as
described below:
•ABC_Prod is backed up to a file, called ABC_Prod.bak, which is performed at 9 PM every day.
•The transaction log is backed up to a file, called ABC_Prod_HHMM.trn, which is executed at 20
minute intervals starting at 09:20 AM.
You receive a report from a ABC.com user, named Mia Hamm, that certain information was
removed by a search which was executed at 09:40 AM.
You are then instructed to ensure that you recover ABC_Prod to its previous status.
Which of the following actions should you take? (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 ABC_Prod database uses a full
recovery model.
To adapt to business requirements, ABC.com now need to make use of a process which changes
20,000 records from the Sales table every day at 10 PM.
You have received instruction to devise a solution that allows any changes to the records to be
changed back while remaining online.
Which of the following actions should you take?

You work as a database administrator at ABC.com.ABC.com makes use of SQL Server 2008 R2.
ABC.com has three database servers, named ABC-SR13, ABC-SR14, and ABC-SR15, which are
each running a different instance of SQL Server 2008. You have configured a database mirroring
session in high-safety mode between ABC-SR13 and ABC-SR14 for an important ABC.com
database. ABC-SR13 is presently configured as the principal server, while ABC-SR14 is
configured as the mirror server. ABC-SR15 is configured as the witness server.
You have been instructed to implement a patch on ABC-SR13 and ABC-SR14 that necessitates
the rebooting of the servers. You are informed that the implementation of the patch should be
done as quickly as possible, and prevent failover for the duration of the process. Furthermore, the
implementation should allow for the database to be active on the server on which the patch has
not been implemented as yet.
You start by stopping the mirroring session.
Which of the following actions should you take NEXT?