SnowPro Core Certification — Question 152

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

Answer options

• A. Default Time Travel Retention is set to 0 days. Maximum Time Travel Retention is 30 days. Fail Safe retention time is 1 day.
• B. Default Time Travel Retention is set to 1 day. Maximum Time Travel Retention is 365 days. Fail Safe retention time is 7 days.
• C. Default Time Travel Retention is set to 0 days. Maximum Time Travel Retention is 90 days. Fail Safe retention time is 7 days.
• D. Default Time Travel Retention is set to 1 day. Maximum Time Travel Retention is 90 days. Fail Safe retention time is 7 days.
• E. Default Time Travel Retention is set to 7 days. Maximum Time Travel Retention is 1 day. Fail Safe retention time is 90 days.
• F. Default Time Travel Retention is set to 90 days. Maximum Time Travel Retention is 7 days. Fail Safe retention time is 356 days.

Correct answer: D

Explanation

The correct answer is D because the Snowflake Enterprise Edition specifies a Default Time Travel Retention of 1 day and a Maximum Time Travel Retention of 90 days, along with a Fail Safe retention time of 7 days. Other options either misstate the default or maximum retention periods, or incorrectly specify the fail-safe time.