none
A question of the MCTS 70-432 RRS feed

  • Question

  • You work as a database administrator at CertKiller.com. CertKiller.com is using a SQL Server
    2008 instance that contains a database named CK_DB1. The CK_DB1 database contains an
    OrderHistory table that has two table partitions which is as follows: The one partition contains the
    entire information and the other partition is null. You then create a process to transfer information
    from the partition which includes information for the oldest month of the Orders table to the proper
    partition of the OrderHistory table. However, you have received instructions to ensure that the
    process is capable of running at double capacity at the end of each month.
    What should you do?
    A. You should consider changing the partition function of the OrderHistory table by using the split
    selection and change the proper partition of the Orders table to the proper.
    B. You should consider changing the configurations of the Transaction Logs.
    C. You should consider changing the Orders table by using the merge selection and change the
    partition function of the Orders table through utilizing the split selection.
    D. You should consider changing the OrderHistory table by using the merge selection and change
    the Orders table by utilizing the merge option.
    E. You should consider changing the partition function of the Orders table through utilizing the split
    and then change the Orders table by using the merge selection.

    Hi,I don't know how to deal with this question,please help me!!!

    • Moved by WeiLin Qiao Monday, April 25, 2011 6:06 AM (From:SQL Server Manageability)
    • Moved by Jonathan KehayiasMVP Tuesday, May 3, 2011 3:53 PM (From:SQL Server Database Engine)
    Thursday, April 21, 2011 2:09 AM

All replies