What are the correct parameters for time travel and fail-safe in the Snowflake Enterprise Edition?

Question

Options

• ADefault Time Travel Retention is set to 0 days.
• BDefault Time Travel Retention is set to 1 day.
• CDefault Time Travel Retention is set to 0 days.
• DDefault Time Travel Retention is set to 1 day.
• EDefault Time Travel Retention is set to 7 days.
• FDefault Time Travel Retention is set to 90 days.

• C
  5% (2)
• D
  93% (38)
• E
  2% (1)

Explanation

In Snowflake Enterprise Edition, the default Time Travel retention period is 1 day. However, Enterprise Edition allows you to extend this up to 90 days for databases, schemas, and tables. Fail-Safe is a separate, non-configurable feature that provides an additional 7 days of data recovery after the Time Travel period expires - it is managed by Snowflake and cannot be adjusted by users. Standard Edition is limited to a maximum of 1 day of Time Travel. The 7-day and 90-day values represent the extended maximum (for some object types) and the Fail-Safe window, not defaults.

No community discussion yet for this question.