You maintain a SQL Server 2008 instance that contains a database named DB1. DB1 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. Your solution must not affect the Web application or impact performance.
What should you do?

• A. Configure access to DB1 to only use stored procedures and functions.
• B. Encrypt the customer data at the folder level by using Encrypted File System (EFS) and then back up the transaction logs.
• C. Encrypt the customer data at the cell level and then back up DB1.
• D. Enable Transparent Database Encryption for DB1 and then back up the transaction logs.

You are managing a SQL Server 2008 instance which includes a database called TesterDB for Home.com. The data file and the transaction log file which are located on the D: drive that owns only 10 percent useful space. You should make sure that you move both files to the G: drive.
Which is the correct answer?

• A. ALTER DATABASE TesterDB SET OFFLINE WITH ROLLBACK_IMMEDIATE;
• B. You should utilize the following Transact-SQL statement.
• C. ALTER DATABASE TesterDB
• D. mdf'); ALTER DATABASE Finance SET MULTI_USER;
• E. Run the following Transact-SQL statements. ALTER DATABASE Finance MODIFY FILE(NAME = Finance_Data, FILENAME =
• F. mdf'); ldf'); ALTER DATABASE TesterDB SET ONLINE;
• G. You should implement the statement below: ALTER DATABASE Finance SET RESTRICTED_USER WITH ROLLBACK_IMMEDIATE; Move the data file and

You maintain a SQL Server 2008 instance.
You use the Resource Governor to manage processor resources on the server for a newly deployed application named App1. App1 is assigned to a custom workload group named MyApp.
You need to monitor processor resources.
What should you do?

• A. Use the request_max_cpu_time_sec column of the sys.resource_governor_workload_groups catalog view.
• B. Use the sys.dm_os_performance_counters to monitor the CPU usage % counter of the SQLServer:Workload Group Stats performance object for the default workload group.
• C. Use the sys.dm_resource_governor_workload_groups dynamic management view to monitor the CPU usage for the default workload group.
• D. Use the sys.dm_os_performance_counters to monitor the CPU usage % counter of the SQLServer:Workload Group Stats performance object for the MyApp workload group.

You administer three SQL Server 2008 instances named Instance1, Instance2, and Instance3. Each of the three instances runs on a separate server. A mission-critical database is mirrored between Instance1 and Instance2. Instance3 is configured as the witness. Instance1 is configured as the Principal. You plan to apply an update to the servers that run Instance1 and Instance2. The update requires a restart.
You need to ensure that the servers meet the following requirements during the update process:
- Complete the update process in the least amount of time possible. - The database must be available on one server during the update of another server. - The update process must not cause an automatic failover of the database.
What should you do?

• A. Suspend the mirroring session Install the update on both servers.
• B. Suspend the mirroring session.
  Install the update on the server that runs Instance2.
  Resume the mirroring session.
  Perform a manual failover of the mirroring session.
  Install the update on the server that runs Instance1.
• C. Remove the mirroring session.
  Run the SQL Server 2008 Upgrade Advisor Install the update on both servers.
  Re-establish the mirroring session.
• D. Remove the mirroring session. Install the update on both servers.
  Re-establish the mirroring session.
• E. Install the update on the server that runs Instance2. Perform a manual failover of the mirroring session. Install the update on the server that runs Instance1.