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…

Partitioned views combine horizontally partitioned data from multiple member tables into a single virtual table and do not provide a mechanism to place different segments of a *single table* on varying storage tiers based on data recency.

A database snapshot provides a static, read-only view of a database at a specific point in time and is not designed for dynamically segregating live data within a table onto different performance-tiered storage.

Change Data Capture (CDC) records insert, update, and delete activity applied to SQL Server tables and is used for tracking changes, not for physically distributing a table's data across different storage types based on age or performance requirements.

Table partitioning in SQL Server allows a large table to be divided into smaller, more manageable partitions based on a partitioning column, such as a date column. These individual partitions can then be placed on different filegroups, which can be configured to reside on different physical storage devices (e.g., SSDs for recent data, HDDs for historical data), thereby optimizing storage performance and cost.