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?

A45 days

B1 day

C7 days

D90 days

Show Suggested 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.

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

by Gerardo at Dec 20, 2025, 06:54 PM

Limited Time Offer

25%

Off

Get Premium SOL-C01 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Janna

17 days ago

I’m not sure, but C) 7 days seems too low.

upvoted 0 times

...

Allene

23 days ago

I agree with A) 45 days. It makes sense for backups.

upvoted 0 times

...

Vanda

28 days ago

I’m leaning towards D) 90 days. More time is better.

upvoted 0 times

...

Kristel

1 month ago

Definitely A) 45 days. That's what I remember.

upvoted 0 times

...

Kayleigh

1 month ago

I feel like it's B) 1 day. Too short otherwise.

upvoted 0 times

...

Bronwyn

1 month ago

I think it's A) 45 days. Seems reasonable.

upvoted 0 times

...

Bernadine

2 months ago

Not sure about that, feels like it should be shorter.

upvoted 0 times

...

Rossana

2 months ago

Definitely 45 days, I've checked!

upvoted 0 times

...

Winfred

2 months ago

Wait, is it really 90 days? That seems long!

upvoted 0 times

...

Curt

2 months ago

I thought it was only 7 days.

upvoted 0 times

...

Aretha

2 months ago

I’m pretty confident it’s 90 days, but I need to double-check my notes on that.

upvoted 0 times

...

Selma

2 months 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

3 months ago

I remember practicing a question like this, and I think the answer was 45 days.

upvoted 0 times

...

Terrilyn

3 months ago

I think the default Time Travel data retention period is 7 days, but I'm not entirely sure.

upvoted 0 times

...

Jolene

4 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

4 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

4 months ago

D) 90 days is the way to go. Who needs time travel data older than that anyway?

upvoted 0 times

...

Ernestine

4 months ago

C) 7 days seems too short. I'd go with D) 90 days.

upvoted 0 times

...

Krissy

4 months ago

I think the answer is D) 90 days. That seems like a reasonable default retention period.

upvoted 0 times

...

Leslie

4 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

5 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

5 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

5 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

5 months ago

It's 45 days, right?

upvoted 0 times

...

Tyra

5 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

5 months ago

I thought it was 45 days.

upvoted 0 times

...