You work as a database administrator at ABC.com. ABC.com makes use of SQL Server 2000
instance.

A current specific job is configured to retrieve a file remotely from a shared network folder via a
CMDExec step. The use of the LocalSystem account has been configured for the SQL Server
Agent service.
You receive an instruction to upgrade the current SQL Server instance to SQL Server 2008 R2.
Subsequent to the upgrade, you notice that the job step is unable to finish its process.
It is imperative that this issue be rectified.
Which of the following actions should you take?

You work as a database administrator at ABC.com. ABC.com makes use of a SQL Server 2008
R2 instance.
You have previously devised a maintenance strategy that allows for the reconstruction of indexes,
as well as database integrity verification. The strategy is also configured to generate reports in the
form of a text file.
You have now been instructed to configure the strategy to forward e-mails to ABC.com operators
whenever the strategy is unsuccessfully implemented.
Which of the following actions should you take?

You work as a database administrator at ABC.com. ABC.com makes use of a SQL Server 2008
R2.
A database is relocated from one instance of SQL Server 2008 R2 to a different instance. A
ABC.com user previously accessed the database using specific credentials, and would like to
make use of those same credentials to access the database.
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.
Which of the following is TRUE with regards to database mirroring? (Choose all that apply.)

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008 R2
instance.
You have been instructed to make sure that all ABC.com’s users, including managers, receive
daily reports via Database Mail. You are then informed that your solution should allow for
managers to receive the report 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 R2 instance contains a database named ABC_DB.
You have employed the SQL Server service to configure the FILESTREAM data container in the
ABC_DB database.
Which of the following options are TRUE with regards to FILESTREAM data? (Choose all that
apply.)

You work as a database administrator at ABC.com. ABC.com is making use of SQL Server 2008
R2.
ABC.com has a server running an instance of SQL Server 2008 R2, which hosts a database
named ABC_Clients.
When ABC_Clients encounter numerous deadlock issues, you configure the instance’s startup
parameters with the necessary trace flags and reboot the instance.
Which of the following is TRUE regarding this configuration?

You work as a database administrator at ABC.com. ABC.com makes use of a SQL Server 2008
R2 instance that includes an On-Line Analytical Processing (OLAP) database.
The OLAP database hosts a dimension table, named ABCClients, which has hourly information
updates configured. As a result, ABCClients has a large quantity of information that is no longer
used.
You have been instructed to make sure that the amount of space used by the ABCClients table is
reduced with as little administrative effort as possible.
Which of the following actions should you take?

You work as a database administrator at ABC.com. ABC.com is planning to migrate a SQL Server
2000 application to SQL Server 2008 R2.
After the migration, you want to keep an eye on the performance of the SQL Server 2008 R2
instance. You then configure a SQL server-side trace that captures the Deprecation
Announcement and Deprecation Final Support event classes.
Which two of the following best describes these two event classes respectively? (Choose two.)