You deploy a database by using SQL Server 2012.

The database contains a table named Table1.

You need to recommend a solution that meets the following requirements:

Stores the most recent data from Table1 by using the fastest storage s

olution possible.

Stores the historical data from Table1 by using a slower storage solution.

What should you recommend?

A. partitioned views

B. a database snapshot

C. change data capture

D. table partitioning