You maintain a SQL Server 2008 instance that contains a database named
AdventureWorks. The AdventureWorks database contains two tables as shown in the
following table:
The OrderHistory table contains two table partitions: one partition contains all data and the
other partition is empty.
You plan to develop a process to move data from the partition that contains data for the
oldest month of the Orders table to the appropriate partition of the OrderHistory table.
You need to ensure that the process can be repeated at the end of every month.
What should you do?
A.
Alter the partition function of the Orders table by using the split option. Alter the Orders
table by using the merge option.
B.
Alter the partition function of the OrderHistory table by using the split option. Switch the
appropriate partition of the Orders table to the appropriate partition of the OrdersHistory
table. Alter the OrderHistory table by using the split option.
C.
Alter the partition function of the Orders table by using the split option. Alter the
OrderHistory table by using the split option. Alter the partition function of the OrderHistory
table by using the merge option. Alter the Orders table by using the merge option.
D.
Alter the partition function of the OrderHistory table by using the split option. Switch the
appropriate partition of the Orders table to the appropriate partition of the OrdersHistory
table. Alter the OrderHistory table by using the merge option. Alter the Orders table by using
the merge option.