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