You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance. ABC.com contains two SQL Server 2008 servers named ABC-DB1 and ABC-DB2. ABCDB1 is configured to automatically run a maintenance job ABC_JOB10 at regular intervals. Alls is

going well for months.
Then one morning your boss, Miss Tess King, notifies you that the ABC_JOB10 has not been run.
How should you do to remedy this situation? Select two.

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance. One morning you are being bugged by your boss. Apparently there are problems with
the SQL Server Agent Service and the SQL Server Agent job.
What steps should you take to obtain more information regarding this problem?

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance. ABC.com contains two SQL Server 2008 computers named ABC-DB1 and ABC-DB2.
Both of these computers contain a copy of a database named ABC_DB. You are using
transactional replication between ABC-DB1 and ABC-DB2 for ABC_DB. The backups of the
databases are as follows:
•Full backup is performed nightly.
•Transaction log backups are performed hourly.
Furthermore, replication delay is less than one minute. ABC_DB becomes corrupt on ABC-DB1
and its state was rendered irreparable. You need to return ABC_DB on ABC-DB1 and ensure that
minimal amount of data loss while you copy the data from ABC-DB2 and minimize the impact on
the users of these servers.
What steps should you take? (Each correct option is part of the answer. Choose TWO)

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance that contains a database named ABC_DB. You want to get yourself acquainted with
Database snapshots.
What T-SQL commands are used to create and remove database snapshots respectively?
Choose all that apply.

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008 Server
that contains a database named ABC_DB. The performance of the server has been decreasing.
After investigation you notice that the ABC_DB database backup files are too large. You have
received instructions from management to cut the content of the entire database backup files of
ABC_DB. Currently the following Transact-SQL command is used:
BACKUP DATABASE ABC_DB TO DISK = ‘f:\ABCbackupfolder\ABC_DB.bak’;

In this scenario how should you change the T-SQL command to decrease the size of the ABC_DB
backup files?

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance that contains a database named ABC_DB. The backup of ABC_DB is as follows:
•Full backup at 17:00
•Differential backup at 19:00
•Database snapshots at 20:00 and 21:00
Furthermore, the backups and the database snapshots are reserved on a different disk. However,
ABC_DB has failed at 20:10. You have received instruction to recover ABC_DB .
What steps should you take to keep the data loss minimum?

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance. Using the Maintenance Plan Wizard you create an appropriate Maintenance plan. The
Maintenance plan works fine, but it is just that your boss, Miss Tess King, in addition wants an email notification to be sent to you and her when there is a problem with running the Maintenance
plan.
How can you please your boss?

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance. You are busy with the setting of the Database Mail profile. You want the Database Mail
profile to send reports to all of the users at ABC.com. You then use the sp_send_dbmail stored
procedure to send reports during office hours. You set everything up and it works fine. There are
no complaints from employees. However, after a week employees complain that they have to wait
too long for the daily reports that are sent through the Database Mail system you have set up.
How can you fix this problem to ensure the fastest delivery of these reports?

You work as a database administrator at ABC.com. The ABC.com network contains a SQL Server
2008 computer named ABC-DB01. ABC-DB01 needs the SQL Server service and the SQL Server
Agent service to start automatically. Besides that, it should also audit all user names and
application names that access the system. Auditing should be on always and the result should be
there for 15 years.
What steps should you take? (Choose all that apply.)

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_DB.
Which service is used when you configure the FILESTREAM data container in the ABC_DB
database?