You work as a Database Administrator (DBA) at a company named ABC.com. The
corporate network includes a SQL Server 2012 infrastructure.
The company has a database named CorpDB and a data warehouse named CorpDW.
You need to create an ETL process to update a large fact table in CorpDW with the prior
day’s data from CorpDB and to remove data that is more than 24 months old from CorpDW.
You need to configure the ETL process to add the new data as quickly as possible,
minimize the amount of logging in the transaction log and minimize the risk of locked
records during the update process.
You partition the fact table by date.
How should you add the new records and remove the old data from the fact table? (Choose
two).

A.
New data should be inserted directly into the fact table.

B.
Old data should be deleted directly from the fact table.

C.
New data should be loaded into the fact table by using staging tables and partition switching.

D.
Old data should be removed from the fact table by using staging tables and partition switching.

Explanation: