You are the administrator of your company network. You are in charge of a SQL Server 2008 instance which contains a database named DGTASK. There’re two tables in the DGTASK database, the table below displays this:The OrderHistory table includes two table partitions; one partition is empty while the other one contains all data. The Orders table includes a table partition for each month.Now you intend to create a process to perform a migration. You want to move data from the partition which contains data for the oldest month of the Orders table to the right partition of the OrderHistory table. So what should you do to make sure that the process can be repeated in the middle of each month.
A.
You should use the split option to change the partition function of the Orders table. And use the merge option to change the Orders table.
B.
You should use the split option to change the partition function of the OrderHistory table.
Switch the appropriate partition of the Orders table to the appropriate partition of the OrdersHistory table. Use the split option to change the OrderHistory table.
C.
You should use the split option to change the partition function of the Orders table. And use the merge option to change the partition function of the OrderHistory table. Use the merge option to change the partition function of the OrderHistory table. And use the merge option to change the orders table.
D.
You should use the split option to change the partition function of the OrderHistory table.
Switch the appropriate partition of the Orders table to the appropriate partistion of the OrdersHistory table. Use the merge option to change the OrderHistory table. And Use the merge option to change the Orders table.