[单选]
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 find a problem that there are three reports which are running slowly. And through detailed analysis， you conclude that no error messages are generated from these reports. Not only the indexing strategy but also the status of the current indexes is tested by you. You confirm that the slow performance of the financial reports is not caused by it. Since you are the technical support， you are required to find out which statement is causing the slow performance.
Which action should be performed first？（）

A . SQL Server Profiler should be run with the Lock：Deadlock event class.
B . The Database Engine Tuning Advisor （DTA） f should be run or at least one hour.
C . SQL Server Profiler should be run with the TSQL_Duration template.
D . The Database Engine Tuning Advisor （DTA） should be run with the default options.

You need to meet the fraud detection requirements. What should you do?（） Use Percentage Sampling in SSIS.。 Use a Neural Network Data mining algorithm.。 Create an SSAS Key Performance Indicator for each account.。 Monitor transactions by using SQL Server Profiler.。地租股份有限公司的最高权力机构是（）。董事会。股东大会。总经理。董事长。 Which document is the final determination of whether or not a TDA is required for a certainproduct?（） SAPR Guide 。 Trigger Criteria 。 Sales Manual 。 EConfig。配气机构按照内燃机的（），定时地打开或关闭进气们或排气门，使空气或可燃混合气体进入气缸或从气缸中排除废气。活塞往复数次。工作顺序。冲程数。结构。

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 find a problem that there are three reports which are running slowly. And through detailed analysis， you conclude that no error messages are generated from these reports. Not only the indexing strategy but also the status of the current indexes is tested by you. You confirm that the slow performance of the financial reports is not caused by it. Since you are the technical support， you are required to find out which statement is causing the slow performance.
Which action should be performed first？（）

参考答案：

● 参考解析

本题暂无解析

当前位置：MCITP(70-447)题库

相关题目: