You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance. ABC.com has a SQL Agent job that contains a Windows PowerShell job step that uses
the SQLCmd function to move data between servers. The SQL Agent job is working fine for a
couple of week. However, occasionally the job fails.

Your CEO tells you that all employees in ABC must be notified by e-mail if this job is not
successfully run.
What steps should you take? (Each correct option is part of the answer. Choose THREE.)

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.

DRAG DROP
You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance. Your CEO tells you that all user-defined stored procedures must have the prefix ABC_.
You must prevent user-defined procedures from being created that do not meet her requirement.
What steps would meet this requirement?

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?