A Snowflake account has the 'DATA RETENTION TIME IN DAYS' parameter set to the maximum allowed value for Enterprise Edition. A user executes a large DELETE statement against a table, removing 90% of i

Question

Options

• AThe data can be recovered using Time Travel because the 'DATA RETENTION TIME IN DAYS'
• BThe data cannot be recovered because the default retention period is only 1 day. The maximum
• CThe data can be recovered, but only if the parameter was explicitly set to extend the retention
• DThe data can be recovered, assuming the parameter was explicitly set to a value greater than or

• A
  12% (4)
• B
  9% (3)
• C
  3% (1)
• D
  76% (26)

Explanation

In Snowflake Enterprise Edition, DATA_RETENTION_TIME_IN_DAYS can be set to a maximum of 90 days (Standard Edition caps at 1 day). Time Travel only retains data for the configured retention period - once that window expires, the data is moved to Fail-safe and is no longer user-accessible via Time Travel. D is correct: recovery is possible only if the parameter was explicitly configured to a value of 60 days or more before the DELETE occurred. A is too absolute - it claims recovery is possible without qualifying that the retention must have been set high enough. B is incorrect - it falsely states the maximum is 1 day (that is only the Standard Edition default; Enterprise allows up to 90). C is partially right but vague - D is the precise, correct statement. If the retention was set to, say, 30 days, the 60-day-old data would be unrecoverable via Time Travel.

No community discussion yet for this question.