You administer a SQL Server 2008 instance. You need to allow users on instance to query remote data sources by using the OPENROWSET() sp_configure configuration option should you configure?

• A. Agent XPs
• B. Ad Hoc Distributed Queries
• C. remote access
• D. remote proc trans

You maintain a SQL Server 2008 instance that contains a database named Finance. The Finance database currently contains 100 GB of data. On an average, 1 GB of data is modified or inserted daily.
The recovery model of the Finance database is set to Simple. Business requirements specify that data loss of more than two hours worth of transactions during business hours is unacceptable.
You need to select a backup strategy that uses the least amount of disk space by adhering to the business requirements.
What should you do?

• A. Perform a full database backup once every week.
  Perform a differential backup once daily.
  Perform a transaction log backup every two hours during business hours.
• B. Perform a full database backup once daily.
  Perform a transaction log backup every two hours during business hours.
• C. Perform a full database backup once daily.
  Perform a differential backup every two horns during business hours.
• D. Perform a full database backup once daily.

You administer a SQL Server 2008 instance that contains a database named AdventureWorks.
The AdventureWorks database contains a table named OrderDetail. You plan to export all data from this table to a file.
You need to ensure that the following data export requirements are met: A Microsoft Office Open XML document format is used The data export process is saved for reuse.
What should you do?

• A. Run the SQLCmd utility and save the output to a file.
• B. Run the bulk copy program utility along with an output file and no format file.
• C. Run the SQL Import and Export Data Wizard and save the output to a file.
• D. Run the bulk copy program utility along with a format file and an output file.

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. A full database backup of all the user databases is performed at 02:00 hours daily. The transaction log backup occurs every 15 minutes. A differential backup is performed every 4 hours.
You plan to perform a full backup of the Finance database at 11:00 hours.
You need to ensure that the backup is performed without affecting the overall backup and restore procedures for the Finance database. You also need to ensure that the backup files are restored in proper sequence.
Which Transact-SQL statement should you use?

• A. BACKUP DATABASE FINANCE TO DISK = 't:\backups\finance.bak` WITH COPY_ONLY:
• B. BACKUP LOG FINANCE TO DISK = 't:\backups\finance.trn';
• C. BACKUP DATABASE FINANCE TO DISK = 't:\backups\finance.bak' WITH NOUNLOAD;
• D. BACKUP DATABASE FINANCE TO DISK = 't:\backups\finance.bak` WITH
  DIFFERENTIAL;

You maintain a SQL Server 2008 instance.
You use SQL Server Database Mail to distribute multiple reports that are scheduled and generated every night. You need to enforce a mail retention policy to delete copies of automatically generated
mails after 60 days. Which process should you use?

• A. Set the Subscription retention interval to delete mails after 60 days.
• B. Create a SQL Agent job to use the sysmail_delete_log_sp stored procedure to delete mails older than 60 days.
• C. Set the MailProfile property of a Management Policy on the Server facet to delete mails after 60 days.
• D. Create a SQL Agent job to use the sysmail_delete_mailitems_sp stored procedure to delete mails older than 60 days.