You maintain a SQL Server 2008 instance that contains a database named Finance.
The most recent full backup was taken at 13:00 horns, a differential backup was taken at
15:00 hours, and database snapshots were created at 16:00 horns and at 17:00 hours. The
backups and the database snapshots are stored on a different disk from the database files.
The hard disk that contains the database files fails at 17:02 hours.
You need to restore the Finance database by ensuring minimal data loss.
What should you do?

You are managing your company database. You manage a SQL Server 2005 database
called ContractTEST, which is down.
You operate a restore by using the following Transact-SQL script. RESTORE DATABASE
ContractTESTFROM contracts_bu_deviceWITH CONTINUE_AFTER_ERROR,

CHECKSUM, RECOVERY After the restore, the SQL Server logs show errors in some page
restores.
What you should do is to repair the database pages, which are down, and facilitates repair
by using the fastest method.
Which is the correct answer?

Yon maintain a SQL Server 2008 instance that contains a database named Finance.
The backup strategy for the Finance database specifies the following requirements:
-Full database backup to a file named finance.bak is performed at 08:00 hours daily.
-A transaction log backup to a file named finance_HHMM.trn is performed every 15 minutes
starting at 08:15 horns.
The Finance database is being used in single-user mode.
At 08:40 hours, a user reports that some important data was accidentally deleted by a query
that was executed at 08:23 horns.
You need to restore the database to its original state.
Which Transact-SQL statement(s) should you use?

You maintain an instance of Microsoft SQL Server 2008. The instance contains a database
named
Finance. The recovery model of the Finance database is set to Full.
You deploy a new process that modifies 10.000 records from the Accounts table at 19:00
hours daily.
You need to ensure that any modification to the data can be reverted without the database
going offline.
Which strategy should you implement?

You maintain a SQL Server 2008 instance.
You have an existing database maintenance plan that performs the following tasks:
-It checks database integrity. -It rebuilds indexes. -It writes a report to a text file.
You need to modify the SQL Server instance such that an e-mail message is sent to the
operators when the maintenance plan fails to execute successfully.
What should you do?

You administer a SQL Server 2008 instance. You configure a single Database Mail profile
that is used to send reports to all the employees of your organization. The sp_send_dbmail

stored procedure is used to send a large volume of reports during business hours. The
reports to the manager take a long time to be delivered.
You need to ensure that the reports to the manager are sent as quickly as possible.
What should you do?

You administer three SQL Server 2008 instances named Instance 1, Instance2, and
Instance3. Each of the three instances runs on a separate server. A mission-critical
database is mirrored between Instance 1 and Instance2. Instances acts as the witness.
Instance 1 currently acts as the Principal.
You plan to apply a patch to both servers. The patch requires a restart of the server.
You need to find out the sequence of steps necessary to ensure that the following
requirements are met:
-The patching process is completed in the shortest possible time. -The database is online on
the partner that currently does not apply the patch. -The database does not failover to the
other partner during this time.
What should you do?

You are managing a SQL Server 2008 computer called SQLTEST1. You should configure
the SQL Server service and the SQL Server Agent service to start automatically, and set

SQLTEST1 to audit all user names and application names that plan to get information from
SQLTEST1. SQLTEST1 must operate auditing always, and you should keep the results for
10 years. Which is the correct answer?

You maintain a default SQL Server 2008 instance.
You plan to configure FILESTREAM data to meet the following requirements:
-Enable FILESTREAM for file I/O streaming access. -Allow remote client computers to have
streaming access to FILESTREAM data.
You need to ensure that FILESTREAM data is enabled.
Which service should you configure?

You need to install a SQL Server 2008 instance for a new application on an existing server
that contains a default SQL Server 2005 instance.
You need to ensure that both database instances are available for their respective certified
third-party applications.
You need to achieve this goal by complying with the following constraints:
-Minimal database administrative effort. -The existing application environments remain
unchanged
What should you do?