You administer a SQL Server 2008 instance. The instance hosts a database that contains
sensitive data. You plan to implement a database backup strategy for the database. You

need to ensure that all backups of the database are encrypted. You also need to prevent
unauthorized access of the backups. What should you do?

You administer a SQL Server 2008 instance that hosts a large financial database. The
database has the following backup strategies: A full database backup is performed once
a week. A differential backup is performed every day. A transaction log backup is
performed every hour. You plan to execute an end-of-year batch process that takes two
hours to run. The batch process will modify about five percent of data within the database.
You need to ensure that if the Finance department does not approve the batch process, the
batch operation can be rolled back in minimum possible time. What should you do prior to
starting the batch process?

You administer a SQL Server 2008 database solution. All data modifications are performed
through stored procedures that use only the INSERT, UPDATE, or DELETE statements.
You are designing a backup strategy. You need to ensure that the following business
requirements are met: The backup strategy supports point-in-time recovery for failure at
any time of day. The transaction log uses the least amount of disk space. What should
you do?

You administer a SQL Server 2008 instance that hosts a database. The backup strategy
used by the database is as shown in the following table. You run a batch process on
Saturday that lasts from 21:00 hr to 23:00 hr. You discover that the batch process is
invalidated because a user has modified some data at 21:05 hr on the same day. You need
to restore the database to its state at the start of the batch process in the least possible
time. What should you do?

You administer a SQL Server 2008 instance that hosts a large database. The following
backup strategy is used for the database: A full database backup is performed at 02:00 hr
every Monday. A differential backup is performed at 23:00 hr every day. A transaction

log backup is performed on an hourly basis. A power failure on Thursday causes the SQL
Server 2008 server to restart at 09:15 hr. Fifteen minutes after the server restarts, the users
report that they are unable to execute certain queries that access customer data. You
discover that the customer data is unmodified after the power failure. When you execute the
DBCC CHECKDB command on the database, you receive the following error message:
Object ID 2814307832, index ID 2, partition ID 83127819437122157, alloc unit ID
82134587923221126 (type In-row data): Page (3421:169) could not be processed. See
other errors for details. Table error: Object ID 2814307832, index ID 2, partition ID
83127819437122157, alloc unit ID 82134587923221126 (type In-row data), page
(3421:169). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 16928422 and
-8. CHECKDB found 0 allocation errors and 2 consistency errors in table ‘tbl_Customer’
(object ID 2814307832). When you execute the sp_help ‘tbl_customer’ stored procedure
you receive the following result set: index_name index_description ————-
———————————- PK clustered located on PRIMARY NCIX nonclustered located on
PRIMARY You need to ensure that the data is available as quickly as possible with minimal
effect on users. What should you do?

You administer a SQL Server 2008 database solution that is log-shipped for high-availability
purposes. The data files of the database are located on drive D. The transaction log files of
the database are located on drive E. You are designing a recovery test plan to meet the
following requirements for the log-shipping solution: The secondary database is brought
online as quickly as possible. The data loss is minimal. The data is in a consistent state.
You need to identify the first step for the recovery test plan when drive D fails. Which step
should you choose?

You administer a SQL Server 2008 instance that hosts a large database. The database has
the following backup strategy: Full database backups are performed weekly. Differential
backups are performed daily. Transaction log backups are performed hourly. The recovery
plan requires you to perform an unscheduled full backup. You need to perform a full
database backup without interrupting the scheduled backup strategy. Which backup option
should you use?

You administer a SQL Server 2008 infrastructure. You design a corporate backup and
recovery strategy that has to be validated. You need to ensure the successful recovery of
any single database from a catastrophic failure without requiring a backup data center in a
different location. Which three tasks should you include? (Each correct answer presents
part of the solution. Choose three.)

You administer a SQL Server 2008 infrastructure. Your company requires capacity planning

information. You need to design a long-term infrastructure monitoring strategy. Which two
tasks should you include in your design? (Each correct answer presents part of the solution.
Choose two.)

You administer a SQL Server 2008 instance. Customers report server performance
degradation because of a newly implemented process. You use Dynamic Management
Views to verify that there are no long running queries. You need to correlate the operating
system performance data with the actual query execution trace by using minimum
administrative effort. What should you do?