You are adding functionality for the MarketingAnalysis database, and the functionality has the results of a query in an e-mail message sent to the marketing supervisors when new sales data has been entered. A method should be implemented to satify this requirement, and the security risks should be cut to the least. Which method should be utilized to achieve the goal?

• A. To achieve the goal, SQL Mail should be utilized.
• B. To achieve the goal, Database Mail should be utilized.
• C. To achieve the goal, a managed stored procedure should be utilized.
• D. To achieve the goal, a command line program that is called by xp_cmdshell should be utilized.

You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions, monitoring the database server, and design deployment. In the company, you major job is the deployment, maintenance and support of Microsoft SQL Server 2005. You work as the database administrator for your company. You are in charge of 20 SQL Server 2005 computers. Other administrators are responsible for monitoring these computers. These administrators need to guarantee that query response times meet company service level agreements (SLAs). Since you are the technical support, you are asked to provide these administrators with a consistent way of monitoring query response times on the servers. What action should you perform to achieve this goal?

• A. The administrators should be asked to monitor cache hit ratio statistics by using System Monitor.
• B. SQL Server Profiler templates should be created. Query start times and end times should be include in the templates. Distribute these templates to the database administrators.
• C. You should write a query. This query queries the sys.dm_db_partition_stats dynamic management view (DMV). This query should be distributed to the administrators.
• D. You should create an XML document that contains the event and column names of the query response times that must be captured in SQL Server Profiler. The XML file should be distributed to the database administrators.

You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions, monitoring the database server, and design deployment. In the company, you major job is the deployment, maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. A SQL Server 2005 application is utilized by the company. A query is executed by the application to return three columns of the nvarchar data type and one column of the XML data type. A WHERE clause is utilized by the query, and all three of the nvarchar columns are contained by the WHERE clause. 5 million rows are included by the table, and 50,000 rows are returned by the query. The performance of the query should be enhanced. Which action should be performed to achieve the goal?

• A. Statistics should be created on the nvarchar columns.
• B. A view should be created, and only the four columns that the query utilizes are contained by a view.
• C. A primary XML index should be created on the XML column.
• D. A composite index should be created on the three nvarchar columns, and INCLUDE should be specified for the XML column.

In order to satisfy the business requirements of the company, the recovery plan for the CRM database needs to be modified. The company assigns this task to you. What action should you perform to accomplish your task?

• A. In order to accomplish your task, the log backups should be changed to run once every two hours.
• B. In order to accomplish your task, every three hours, differential backups should be added.
• C. In order to accomplish your task, the log backups should be changed to run twice per hour.
• D. In order to accomplish your task, use full backups to take the place of the nightly differential backups.
• E. In order to accomplish your task, the full backups should be changed to run every night.

You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions, monitoring the database server, and design deployment.
In the company, you major job is the deployment, maintenance and support of Microsoft SQL Server 2005. You work as the administrator of a SQL Server 2005 computer. And recently the server performs gradually slowly. The indexing environment is troubleshooted by you. The clustered indexes are rebuilt by you, and the clustered indexes are utilized the most frequently. The most frequently accessed nonclustered index will be optimized by you. The sys.dm_db_index_usage_stats dynamic management view (DMV) is accessed by you. You can see the results from the table listed below.

When the entire index is not read, the nonclustered index which is being utilized the most frequently should be identified. From the following four object_id and index_id combinations, which one should be utilized to finish the task?

• A. To finish the task, the object_id 2066106401 and the index_id 2 should be utilized.
• B. To finish the task, the object_id 869578136 and the index_id 1 should be utilized.
• C. To finish the task, the object_id 2066106401 and the index_id 1 should be utilized.
• D. To finish the task, the object_id 869578136 and the index_id 5 should be utilized.
• E. To finish the task, the object_id 309576141 and the index_id 1 should be utilized.