[单选]

You are a professional level SQL Sever 2008 Database Administrator in an international corporation named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing and sustaining the database life cycle. In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization. A SQL Server 2008 infrastructure is managed by you. A maintenance strategy should be designed for a mission-critical database, and a large table named Orders is contained by the database. Index maintenance operations are contained in the design plan. When you design the strategy, the facts listed below should be taken into consideration. First, the users continuously access to the Orders table in the database. Secondly, a column of the xml data type is contained by Orders table.  Thirdly, the new rows are regularly added to the Orders table. Fourthly, the average fragmentation for the clustered index of the Orders table is no more than 2 percent.   
A strategy should be designed to have the performance of the queries on the table optimized.   
Which action will you perform?（）

决策过程的四个阶段是（） 收集、情报、选择、实施。 情报、选择、实施、评价。 情报、设计、选择、评价。 情报、设计、选择、实施。 You have a single Active Directory directory service domain with three sites named Site1，Site2，and  Site3. There are site links between all three sites，and replication between sites occurs every 30 minutes. You need to ensure that all replication traffic is routed through Site2.  What should you do？（）    Define a preferred bridgehead server for Site2.。  Reduce the interval between replications between Site1 and Site2 and between Site2 and Site3.。  Decrease the cost of the site link between Site1 and Site3.。  Increase the cost of the site link between Site1 and Site3.。 Your network contains an Active Directory forest. The forest contains two domains.  You have a standalone root certification authority （CA）.   On a server in the child domain， you run the Add Roles Wizard and discover that the option to select an  enterprise CA is disabled.   You need to install an enterprise subordinate CA on the server.   What should you use to log on to the new server（） an account that is a member of the Certificate Publishers group in the child domain。 an account that is a member of the Certificate Publishers group in the forest root domain。 an account that is a member of the Schema Admins group in the forest root domain。 an account that is a member of the Enterprise Admins group in the forest root domai。 你的网络中有一个主办公室和一个分支办公室。分支办公室有5台运行Windows 7的客户端计算机。所有客户端计算机都配置了使用BranchCache。在分支办公室，一台名为Computer1的计算机体验到性能问题。你需要临时避免所有计算机从Computer1上获取缓存内容，你应该在Computer1上做什么？（） 在命令提示符中，运行Netsh branchcache flush。 在命令提示符中，运行Netsh branchcache dump。 在网络文件组策略设置修改BranchCache配置。 在客户计算机缓存组策略设置中修改使用磁盘空间百分比设置。 数据库的数据模型是指（） 数据项之间的联系形式。 记录型之间的联系形式。 文件之间的联系形式。 数据之间的联系形式。

You are a professional level SQL Sever 2008 Database Administrator in an international corporation named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing and sustaining the database life cycle. In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization. A SQL Server 2008 infrastructure is managed by you. A maintenance strategy should be designed for a mission-critical database, and a large table named Orders is contained by the database. Index maintenance operations are contained in the design plan. When you design the strategy, the facts listed below should be taken into consideration. First, the users continuously access to the Orders table in the database. Secondly, a column of the xml data type is contained by Orders table.  Thirdly, the new rows are regularly added to the Orders table. Fourthly, the average fragmentation for the clustered index of the Orders table is no more than 2 percent.   
A strategy should be designed to have the performance of the queries on the table optimized.   
Which action will you perform?（）