Answer-first summary for fast verification
Answer: Default Time Travel Retention is set to 1 day. Maximum Time Travel Retention is 90 days. Fail Safe retention time is 7 days.
Based on Snowflake documentation and the community consensus with 100% agreement and multiple upvoted confirmations, option D provides the correct parameters for Snowflake Enterprise Edition. The default Time Travel retention is 1 day, maximum Time Travel retention is 90 days, and Fail Safe retention is 7 days. Other options are incorrect: A has wrong maximum Time Travel (30 days) and Fail Safe (1 day); B has wrong maximum Time Travel (365 days); C has wrong default Time Travel (0 days); E and F have completely reversed or incorrect values for all parameters.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
What are the time travel and fail-safe capabilities available in Snowflake Enterprise Edition?
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.