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
Cathrine
3 hours ago
C) 7 seems too short for data retention.
upvoted 0 times
...
Corrie
5 days ago
I remember reading about 90 days in the docs.
upvoted 0 times
...
Marylyn
10 days ago
I feel confused about this one.
upvoted 0 times
...
Denise
16 days ago
No way, it's definitely D) 90 days.
upvoted 0 times
...
Rory
21 days ago
Really? I thought it was C) 7 days.
upvoted 0 times
...
Amie
26 days ago
I think it's D) 90 days.
upvoted 0 times
...
Timothy
1 month ago
Yep, 90 days is correct!
upvoted 0 times
...
Cyndy
1 month ago
Wait, are you sure? That seems like a long time!
upvoted 0 times
...
Natalie
1 month ago
Definitely 90 days, no doubt about it.
upvoted 0 times
...
Mari
2 months ago
I thought it was only 7 days?
upvoted 0 times
...
Shad
2 months ago
It's 90 days for standard accounts!
upvoted 0 times
...
Galen
2 months ago
I feel like it’s 7 days for standard accounts, but I can’t recall the exact details from my notes.
upvoted 0 times
...
Karan
2 months ago
I’m pretty confident that the maximum duration is 90 days, but I might be confusing it with enterprise accounts.
upvoted 0 times
...
Anglea
2 months ago
I practiced a similar question, and I believe the answer is 1 day, but I could be mixing it up with another feature.
upvoted 0 times
...
Veta
2 months 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
...
Willard
3 months ago
I recall reading that standard accounts have a shorter retention period, so I’m leaning towards 7 days.
upvoted 0 times
...
Mayra
4 months ago
I’m a bit confused; I thought it was 90 days, but that might be for enterprise accounts.
upvoted 0 times
...
Helga
4 months ago
I practiced a similar question, and I feel like the answer was definitely 7 days for standard accounts.
upvoted 0 times
...
Eladia
4 months 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