What feature of Snowflake Continuous Data Protection can be used for maintenance of historical data?

Snowflake Time Travel is a core feature of Continuous Data Protection (CDP) that allows users to access historical versions of data at any point within a defined retention period (up to 90 days). This enables the maintenance of historical data by allowing users to perform queries on past data, restore tables to a previous state, and clone historical versions of tables. It is specifically designed for users to easily access and manipulate recent historical data without needing to restore from traditional backups.

A. Access control: This is a security feature that manages user permissions and privileges to access and modify objects, not a feature for maintaining historical data versions.
B. Fail-safe: This is a disaster recovery feature for data that is lost after the Time Travel retention period has ended. It is not directly accessible by users for maintenance.
C. Network policies: This is a security feature used to restrict access to a Snowflake account based on user IP addresses, which is unrelated to data history.

1. Snowflake Documentation - Understanding & Using Time Travel: "Snowflake Time Travel enables accessing historical data (i.e. data that has been changed or deleted) at any point within a defined period." This directly supports its use for maintaining and accessing historical data.

Source: Snowflake Inc. (2023). Understanding & Using Time Travel. Snowflake Documentation. Retrieved from https://docs.snowflake.com/en/user-guide/data-time-travel

2. Snowflake Documentation - Introduction to Continuous Data Protection: This document outlines the features of CDP, explicitly listing Time Travel and Fail-safe. It describes Time Travel as the mechanism for accessing recent historical data.

Source: Snowflake Inc. (2023). Introduction to Continuous Data Protection. Snowflake Documentation. Retrieved from https://docs.snowflake.com/en/user-guide/data-cdp

3. Snowflake Documentation - Understanding & Using Fail-safe: "Fail-safe is not intended as a means for accessing historical data... For accessing historical data, Snowflake provides Time Travel, which is a much more cost-effective and efficient solution."

Source: Snowflake Inc. (2023). Understanding & Using Fail-safe. Snowflake Documentation. Retrieved from https://docs.snowflake.com/en/user-guide/data-failsafe

4. Snowflake Documentation - Overview of Access Control: This page defines access control in terms of privileges, roles, and securable objects, confirming it is a security, not a data history, feature.

Source: Snowflake Inc. (2023). Overview of Access Control. Snowflake Documentation. Retrieved from https://docs.snowflake.com/en/user-guide/security-access-control-overview