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 4 Question 5 Discussion

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

What is the default Time Travel data retention period?

Show Suggested Answer Hide Answer
Suggested Answer: B

The default Time Travel retention period for most objects in Snowflake is1 day(24 hours). Time Travel enables access to historical versions of data after updates, deletes, or drops. It also allows cloning databases, schemas, and tables at previous points in time, and recovering dropped objects.

While Snowflake Enterprise Edition and higher tiers allow retention periods up to 90 days, this extended window is not the default---administrators must explicitly configure it for each table, schema, or database.

Retention periods of 7, 45, or 90 days are possible only with higher service editions; the default for all accounts and objects remains 1 day unless explicitly overridden.

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


Contribute your Thoughts:

0/2000 characters
Bernadine
3 days ago
Not sure about that, feels like it should be shorter.
upvoted 0 times
...
Rossana
8 days ago
Definitely 45 days, I've checked!
upvoted 0 times
...
Winfred
13 days ago
Wait, is it really 90 days? That seems long!
upvoted 0 times
...
Curt
18 days ago
I thought it was only 7 days.
upvoted 0 times
...
Aretha
23 days ago
I’m pretty confident it’s 90 days, but I need to double-check my notes on that.
upvoted 0 times
...
Selma
28 days ago
I have a feeling it might be 1 day, but I could be mixing it up with another topic we covered.
upvoted 0 times
...
Evangelina
2 months ago
I remember practicing a question like this, and I think the answer was 45 days.
upvoted 0 times
...
Terrilyn
2 months ago
I think the default Time Travel data retention period is 7 days, but I'm not entirely sure.
upvoted 0 times
...
Jolene
2 months ago
D) 90 days, of course. Unless you're a time traveler yourself, in which case, what's the point?
upvoted 0 times
...
Brynn
2 months ago
I'm going with D) 90 days. Anything less and you might as well not have time travel at all.
upvoted 0 times
...
Solange
2 months ago
D) 90 days is the way to go. Who needs time travel data older than that anyway?
upvoted 0 times
...
Ernestine
3 months ago
C) 7 days seems too short. I'd go with D) 90 days.
upvoted 0 times
...
Krissy
3 months ago
I think the answer is D) 90 days. That seems like a reasonable default retention period.
upvoted 0 times
...
Leslie
3 months ago
I've got a good feeling about option A. 45 days sounds right, but I'll double-check my understanding just to be safe.
upvoted 0 times
...
Asha
3 months ago
Wait, I'm a bit confused. I thought it was 45 days, but now I'm second-guessing myself. I'll have to review my notes to be sure.
upvoted 0 times
...
Elmira
3 months ago
Okay, I remember learning about Time Travel data retention in class. I believe the default is 90 days, so I'll choose option D.
upvoted 0 times
...
Lynsey
3 months ago
I'm not totally sure about this one. I'll have to think it through carefully before selecting an answer.
upvoted 0 times
...
Cherry
4 months ago
It's 45 days, right?
upvoted 0 times
...
Tyra
4 months ago
Hmm, I think the default Time Travel data retention period is 7 days, so I'll go with option C.
upvoted 0 times
Joseph
4 months ago
I thought it was 45 days.
upvoted 0 times
...
...

Save Cancel