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

Answer: D

Latest 70-764 Dumps Valid Version with 451 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments