You administer a Microsoft SQL Server 2008 R2 instance. You need to rectify a damaged index without losing any data. What should you do?

• A. Execute DBCC CHECKDB along with the REPAIR_REBUILDcla.se
• B. Execute DBCC CHECKD
• C. Use the RESTORE DATABASEstatement along with the PAGESclause. Apply any differential and log backups. Create a new log backup and then restore the new log backup.
• D. Execute sp_helpfile.
• E. Use the ALTER DATABASEstatement along with the SET EMERGENCYclause.
• F. Use the RESTORE DATABASEstatement along with the PAGESclause. Create a new log backup. Apply all differential and log backups, including the most recent backup.
• G. Examine the msdb..suspect_pagestable.
• H. Execute DBCC CHECKDBalong with the REPAIR_FASTclause.
• I. Restore the database from the most recent full backup. Apply any differential and log backups.

You maintain a SQL Server 2008 instance that contains a database named CustomerDB. The CustomerDB database stores customer data for the company. The customers use a Web application to access their profile data.
You need to protect the customer data such that data files, log files, and subsequent backups are as secure as possible even if the backup media is lost. You want to achieve this goal without affecting the Web application.
What should you do?

• A. Make the CustomerDB database accessible only through stored procedures and functions.
• B. Encrypt the sensitive data at the cell level by using the built-in encryption functions.
• C. Enable Transparent Database Encryption for both the CustomerDB database and the master database.
• D. Enable Transparent Database Encryption for the CustomerDB database and back up the transaction log.

You administer a Microsoft SQL Server 2008 R2 database that contains an OrderItems table. The table has the following definition:

Currently, the table is partitioned by Quarter. You need to make the table unpartitioned.
What should you do?

• A. Use the ALTER TABLEstatement to remove the COLLATEoption.
• B. Use the ALTER PARTITION FUNCTION ... SPLIT RANGE statement.
• C. Create a new table.
  Use the ALTER TABLE statement along with the SWITCH PARTITION clause.
  Use the ALTER PARTITION FUNCTION statement along with the MERGE RANGE
  clause.
• D. Execute the DBCC CLEANTABLEcommand on the OrderItems table.
• E. Create a new Filegroup.
  Create a new database File.
  Use the ALTER PARTITION SCHEME statement along with the NEXT USED clause.
  Use the ALTER PARTITION FUNCTION statement along with the SPLIT RANGE clause.
• F. Run the following statement:
  EXECUTE sp_tableoption
  @TableNamePattern ='OrderItem3',
  @OptionName= 'PartltionByYear';
  @OptionValue= 'true';
• G. Create a new partition function.
  Create a new partition scheme.
  Add a clustered index to place the data onto the partition scheme.
• H. Remove the clustered index from the table.
• I. Create a new filegroup.
  Create a new database file.
  Use the ALTER PARTITION SCHEME statement along with the NEXT USED clause.
  Use ALTER INDEX REORGANIZE statement.
• J. Run the following statement:
  CREATE PARTITION SCHEME SEC_FG
  AS PARTITION FUNC_FG
  ALL TO (SECONDARY);

You maintain several SQL Server 2008 instances. You need to ensure that the names of all user-defined stored procedures contain the prefix usp_ on all instances.
You also need to ensure that you cannot create stored procedures that do not contain this prefix.
What should you do?

• A. Create a policy that targets the name of the stored procedure that is evaluated on change.
• B. Create a condition that targets the name of the stored procedure that is evaluated on change.
• C. Create a condition that targets the name of stored procedure that is evaluated on demand.
• D. Create a policy that targets the name of the stored procedure that is evaluated on demand.