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
Answer: D
Latest 70-764 Dumps Valid Version with 451 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund