Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Snowflake SOL-C01 Exam - Topic 2 Question 10 Discussion

What is the maximum duration of data retention using Time Travel in Snowflake for standard accounts?
B) 1
A) 0
C) 7
D) 90

Snowflake SOL-C01 Exam - Topic 2 Question 10 Discussion

Actual exam question for Snowflake's SOL-C01 exam
Question #: 10
Topic #: 2
[All SOL-C01 Questions]

What is the maximum duration of data retention using Time Travel in Snowflake for standard accounts?

Show Suggested Answer Hide Answer
Suggested Answer: B

For Snowflake Standard Edition accounts, the maximum Time Travel retention period is1 day(24 hours). Time Travel allows users to query historical data, restore dropped objects, and clone objects at a point in time. Although the retention period can be adjusted at the account, database, schema, or table level, Standard Edition restricts the upper limit to 1 day. A value of 0 disables Time Travel entirely. A 7-day retention period applies to Fail-safe, not Time Travel, and Fail-safe is a disaster-recovery mechanism managed exclusively by Snowflake. The 90-day Time Travel retention is available only for Enterprise Edition and above. Therefore, the correct maximum retention period for Standard Edition is 1 day.

=======================================


Contribute your Thoughts:

0/2000 characters
Mayra
1 month ago
I’m a bit confused; I thought it was 90 days, but that might be for enterprise accounts.
upvoted 0 times
...
Helga
1 month ago
I practiced a similar question, and I feel like the answer was definitely 7 days for standard accounts.
upvoted 0 times
...
Eladia
1 month ago
I think I remember something about Time Travel, but I'm not sure if it's 7 or 90 days for standard accounts.
upvoted 0 times
...

Save Cancel