欢迎来到在线考试题库网 在线考试题库官网
logo
全部科目 > 微软认证考试 > MCITP > MCITP(70-450)

单项选择题

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?()

    A.The clustered index of the Orders table should be dropped.
    B.The clustered index of the Orders table offline should be rebuilt once a month.
    C.The clustered index of the Orders table should be excluded from scheduled reorganizing or rebuilding operations.
    D.The clustered index of the Orders table should be reorganized by reducing the fill factor.

点击查看答案

相关考题

微信小程序免费搜题
微信扫一扫,加关注免费搜题

微信扫一扫,加关注免费搜题