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

问题:

[单选]

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. You find a problem that when the following query is executed, a SQL Server 2005 application will perform slowly. SELECT * FROM Orders WHERE OrderStatus = ’InProgress’ This query is executed by the application as an ad hoc query. In most occasions, this query performs much more quickly. The company has the OrderStatus column indexed. The value InProgress is included by only a small number of the rows. Nevertheless, the OrderStatus column index which is the most ideal for this query is not being utilized. The performance of this query should be enhanced. However, the application that executes the query should not be changed. In addition, the effect on end users should be cut to the least. 
Which action should be performed to finish the task?()

A . To finish the task, the index should be built by utilizing a FILLFACTOR of 10 percent.
B . To finish the task, the index should be recreated to have all of the columns in the table included.
C . To finish the task, an indexed view of the Orders table should be viewed.
D . To finish the task, the statistics should be updated on the index.

In order to link data centers, a customer is evaluating the installation of fiber optic cable between buildings that are 400 meters apart. The installation will require multiple patch panels and cables. Which of the following is the most critical factor to consider for this installation?() I/O rate。 bandwidth。 signal loss。 Dense Wavelength Division Multiplexing (DWDM)。 周卫报告中指出:以“公共性”、“民主主义”、“卓越性”三大原理作为()的哲学。 Which of the following is required to ensure the completion of all tests within the automated procedure of thecluster test tool?() Application monitoring has been configured。 Only disk heartbeat networks have been used。 Cluster nodes are attached to two IP networks。 Resource Group dependencies have been configured。 当先前获得的客户身份资料的真实性、有效性、完整性存在疑点时,金融机构应当重新识别客户。 通过对实际进度数据和计划目标数据分析比较,确定施工进度计划的偏差及其大小,进而分析产生偏差原因,制订(),确保计划目标实现。 资金计划。 施工方案。 纠偏措施。 进度计划。

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. You find a problem that when the following query is executed, a SQL Server 2005 application will perform slowly. SELECT * FROM Orders WHERE OrderStatus = ’InProgress’ This query is executed by the application as an ad hoc query. In most occasions, this query performs much more quickly. The company has the OrderStatus column indexed. The value InProgress is included by only a small number of the rows. Nevertheless, the OrderStatus column index which is the most ideal for this query is not being utilized. The performance of this query should be enhanced. However, the application that executes the query should not be changed. In addition, the effect on end users should be cut to the least. 
Which action should be performed to finish the task?()

参考答案:

  参考解析

本题暂无解析

在线 客服