What features does Snowflake Time Travel enable?

What features does Snowflake Time Travel enable?
A . Querying data-related objects that were created within the past 365 days
B . Restoring data-related objects that have been deleted within the past 90 days
C . Conducting point-in-time analysis for Bl reporting
D . Analyzing data usage/manipulation over all periods of time

View Answer

Answer: B, C

Explanation:

Snowflake Time Travel is a powerful feature that allows users to access historical data within a defined period.

It enables two key capabilities:

B. Restoring data-related objects that have been deleted within the past 90 days: Time Travel can be used to restore tables, schemas, and databases that have been accidentally or intentionally deleted within the Time Travel retention period.

C. Conducting point-in-time analysis for BI reporting: It allows users to query historical data as it appeared at a specific point in time within the Time Travel retention period, which is crucial for business intelligence and reporting purposes.

While Time Travel does allow querying of past data, it is limited to the retention period set for the Snowflake account, which is typically 1 day for standard accounts and can be extended up to 90 days for enterprise accounts. It does not enable querying or restoring objects created or deleted beyond the retention period, nor does it provide analysis over all periods of time.

Reference: Snowflake Documentation on Time Travel

SnowPro® Core Certification Study Guide