Snowflake Exam SnowPro-Core Topic 7 Question 99 Discussion

Actual exam question for Snowflake's SnowPro-Core exam

Question #: 99
Topic #: 7

Which parameter can be set at the account level to set the minimum number of days for which Snowflake retains historical data in Time Travel?

ADATA_RETENTION_TIME_IN_DAYS

BMAX_DATA_EXTENSION_TIME_IN_DAYS

CMIN_DATA_RETENTION_TIME_IN_DAYS

DMAX CONCURRENCY LEVEL

Show Suggested Answer

Suggested Answer: A

The parameterDATA_RETENTION_TIME_IN_DAYScan be set at the account level to define the minimum number of days Snowflake retains historical data for Time Travel1.

by Lillian at Sep 13, 2024, 03:31 PM

Limited Time Offer

25%

Off

Get Premium SnowPro-Core Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Jill

2 months ago

I love how they throw in a completely random option like D) MAX CONCURRENCY LEVEL just to mess with us. Classic Snowflake exam tactics!

upvoted 0 times

Celeste

23 days ago

A) DATA_RETENTION_TIME_IN_DAYS

upvoted 0 times

...

Maybelle

24 days ago

Yeah, it's like they want us to second guess ourselves.

upvoted 0 times

...

Niesha

25 days ago

C) MIN_DATA_RETENTION_TIME_IN_DAYS

upvoted 0 times

...

Emerson

1 months ago

I know right, they always try to trick us with those random options!

upvoted 0 times

...

Lorean

1 months ago

A) DATA_RETENTION_TIME_IN_DAYS

upvoted 0 times

...

Natalya

3 months ago

Hmm, I think B) MAX_DATA_EXTENSION_TIME_IN_DAYS sounds more like what we're looking for. Gotta keep that data around as long as possible, right?

upvoted 0 times

Craig

2 months ago

I see, thanks for clarifying. It's important to set the right parameter to retain historical data.

upvoted 0 times

...

Mindy

2 months ago

I think C) MIN_DATA_RETENTION_TIME_IN_DAYS is the correct parameter to set.

upvoted 0 times

...

Gerardo

2 months ago

Actually, A) DATA_RETENTION_TIME_IN_DAYS is the parameter that controls the minimum number of days for Time Travel data retention.

upvoted 0 times

...

Kerry

3 months ago

Haha, D) MAX CONCURRENCY LEVEL? Nice try, but that's clearly not related to data retention. I'm going with C as well.

upvoted 0 times

Nicolette

3 months ago

C) MIN_DATA_RETENTION_TIME_IN_DAYS

upvoted 0 times

...

Jesusita

3 months ago

B) MAX_DATA_EXTENSION_TIME_IN_DAYS

upvoted 0 times

...

Eura

3 months ago

A) DATA_RETENTION_TIME_IN_DAYS

upvoted 0 times

...

Fausto

3 months ago

I'm not sure, but C) MIN_DATA_RETENTION_TIME_IN_DAYS also sounds plausible.

upvoted 0 times

...

Gearldine

3 months ago

I agree with Vallie, setting the minimum number of days for data retention makes sense.

upvoted 0 times

...

Peggie

3 months ago

I'm pretty sure the answer is C) MIN_DATA_RETENTION_TIME_IN_DAYS. That just sounds like the most logical choice for setting the minimum days for Snowflake's time travel feature.

upvoted 0 times

Ruthann

2 months ago

I agree with you, C) MIN_DATA_RETENTION_TIME_IN_DAYS seems like the right choice.

upvoted 0 times

...

Dahlia

2 months ago

I'm not sure, but I think it might be B) MAX_DATA_EXTENSION_TIME_IN_DAYS.

upvoted 0 times

...

Lilli

2 months ago

No, I believe it's C) MIN_DATA_RETENTION_TIME_IN_DAYS.

upvoted 0 times

...

Starr

3 months ago

I think it's A) DATA_RETENTION_TIME_IN_DAYS.

upvoted 0 times

...

Vallie

3 months ago

I think the answer is A) DATA_RETENTION_TIME_IN_DAYS.

upvoted 0 times

...