PrepAway - Latest Free Exam Questions & Answers

Tag: you decide to 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

What should you do to ensure that the process is capable of running at double capacity at the end of each mont

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?