You administer a SQL Server 2008 instance.
The instance hosts a database that is used by a Web-based application. The application processes 15,000 transactions every minute. A table in the database contains a column that is used only by the application. This column stores sensitive data.
You need to store the sensitive data in the most secure manner possible.
You also need to ensure that you minimize the usage of memory space and processor time.
Which encryption type should you use?

• A. Certificate-based encryption
• B. Transparent data encryption
• C. Asymmetric key encryption
• D. Symmetric key encryption

You are a professional level SQL Sever 2008 Database Administrator.
A monitoring solution should be designed for the instance to have object utilization statistics monitored. A list of first 10 objects should be identified by the solution for each of the following two components:
most frequently executed stored procedures and functions
long running Transact-SQL statements
The monitoring solution should be implemented with minimum performance effect, and the least amount of administrative effort should be utilized.
Which action will you perform to accomplish the task?

• A. To accomplish the task, a System Monitor counter log should be utilized.
• B. To accomplish the task, a client-side SQL Server Profiler trace should be utilized.
• C. To accomplish the task, dynamic management views should be utilized.
• D. To accomplish the task, a server-side SQL Server Profiler trace should be utilized.

You administer a SQL Server 2008 infrastructure.
You plan to design a maintenance strategy for a mission-critical database that includes a large table named Orders. The design plan includes index maintenance operations.
You must design the strategy after considering the following facts:
The Orders table in the database is constantly accessed.
New rows are frequently added to the Orders table.
The average fragmentation for the clustered index of the Orders table is less than 2 percent.
The Orders table includes a column of the xml data type.
You need to implement the strategy so that the performance of the queries on the table is optimized.
What should you do?

• A. Exclude the clustered index of the Orders table from scheduled reorganizing or rebuilding operations.
• B. Rebuild the clustered index of the Orders table offline once a month.
• C. Drop the clustered index of the Orders table.
• D. Reorganize the clustered index of the Orders table by decreasing the fill factor.

You administer a SQL Server 2008 instance.
Your company security policy is designed to prevent changes to the server to the server configuration. You plan to use Policy-Based Management Framework to implement the security policy.
You need to ensure that the policy is configured to meet the security requirement.
What should you do?

• A. Enable the nested triggers server configuration option.
• B. Disable the nested triggers server configuration.
• C. Use the Local Service account for the SQLAgent service.
• D. Use a domain account for the SQLAgent service.

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?

• A. Restore the full database backup that was performed on Saturday. Restore all transaction logs from the time of the full backup on Saturday and stop at 21:00 hr on Saturday.
• B. Restore the full database backup that was performed on Saturday.
• C. Restore the full database backup that was performed on Thursday Restore all transaction logs from the time of the full backup on Thursday and stop at 21:00 hr on Saturday.
• D. Restore the full database backup that was performed on Thursday. Restore the differential backup that was performed on Friday. Restore all transaction logs from the time of the differential backup on Friday and stop at 21:00 hr on Saturday.