What should you recommend?

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

View Answer

Answer: D