You work as a database administrator at Domain.com. Domain.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.