You work as a database administrator at ABC.com.ABC.com is using a SQL Server 2008 R2
instance that contains a database named ABC_DB1.
The ABC_DB1 database contains a SalesHistory table that has two table partitions. All information
in the SalesHistory table is located in the one partition, while the other partition has no information.
You then create a process to transfer information from the partition, which includes information for
the oldest month of the Sales table, to the proper partition of the SalesHistory table.
You have received instructions to ensure that the process is capable of running at double capacity
at the end of each month.
Which of the following actions should you take?
A.
You should consider changing the configuration of the Event Logs.
B.
You should consider changing the configuration of the Transaction Logs.
C.
You should consider changing the configuration of the Trace Logs.
D.
You should consider configuring the use of Database snapshots.
Explanation: