What features does Snowflake Time Travel enable?

The correct answer is B. Restoring data-related objects that have been deleted within the past 90 days C. Conducting point-in-time analysis for BI reporting: It allows users to query historical data as it. Snowflake Time Travel enables two key capabilities: (B) restoring data-related objects (tables, schemas, databases) that have been deleted or modified, within a configurable retention period up to 90 days on Enterprise edition; and (C) querying historical data at a specific point

Data Protection and Data Sharing

Question

Options

AQuerying data-related objects that were created within the past 365 days
BRestoring data-related objects that have been deleted within the past 90 days
CConducting point-in-time analysis for BI reporting: It allows users to query historical data as it
DAnalyzing data usage/manipulation over all periods of time

How the community answered

(13 responses)

A
8% (1)
B
85% (11)
D
8% (1)

Explanation

Snowflake Time Travel enables two key capabilities: (B) restoring data-related objects (tables, schemas, databases) that have been deleted or modified, within a configurable retention period up to 90 days on Enterprise edition; and (C) querying historical data at a specific point in time using AT or BEFORE clauses, which is essential for point-in-time analysis and BI reporting. Option A is incorrect because Time Travel doesn't operate on a 365-day window for creation queries - it's focused on change/deletion history within the retention period. Option D is incorrect because Time Travel is bounded by the retention period (1 day on Standard, up to 90 days on Enterprise), not all periods of time.

Topics

#Time Travel#Data Recovery#Point-in-Time Querying#Data Protection

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice