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 solution 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
