Snowflake Exam SnowPro-Core Topic 7 Question 97 Discussion

Actual exam question for Snowflake's SnowPro-Core exam

Question #: 97
Topic #: 7

[All SnowPro-Core Questions]

What happens when a Snowflake user changes the data retention period at the schema level?

AAll child objects will retain data for the new retention period.

BAll child objects that do not have an explicit retention period will automatically inherit the new retention period.

CAll child objects with an explicit retention period will be overridden with the new retention period.

DAll explicit child object retention periods will remain unchanged.

Show Suggested Answer

Suggested Answer: B

When the data retention period is changed at the schema level, all child objects that do not have an explicit retention period set will inherit the new retention period from the schema4.

by Shaun at Sep 19, 2024, 06:25 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Rosamond

2 months ago

D seems too good to be true. There's no way all the explicit child object retention periods would just stay the same. I'm guessing it's B.

upvoted 0 times

...

Devorah

2 months ago

Haha, who even changes data retention periods at the schema level? That's like a superpower move. Anyway, I think it's B.

upvoted 0 times

Sage

20 days ago

I think you're mistaken, it's actually D) All explicit child object retention periods will remain unchanged.

upvoted 0 times

...

Stacey

28 days ago

I'm pretty sure it's C) All child objects with an explicit retention period will be overridden with the new retention period.

upvoted 0 times

...

Armando

1 months ago

No, I believe it's B) All child objects that do not have an explicit retention period will automatically inherit the new retention period.

upvoted 0 times

...

Brittni

1 months ago

I think it's A) All child objects will retain data for the new retention period.

upvoted 0 times

...

Art

2 months ago

I'm going with C. Wouldn't make sense for the explicit retention periods to remain unchanged, right? The schema-level change should override them.

upvoted 0 times

Armando

28 days ago

User3: I agree, C seems like the most logical choice in this scenario.

upvoted 0 times

...

Enola

1 months ago

User2: Yeah, that's what I was thinking too. It wouldn't make sense for the explicit retention periods to remain unchanged.

upvoted 0 times

...

Antonette

1 months ago

I think C makes sense. The schema-level change should override the explicit retention periods.

upvoted 0 times

...

Dalene

3 months ago

I'm leaning towards C because it makes sense to me.

upvoted 0 times

...

Shelba

3 months ago

I believe it's B.

upvoted 0 times

...

Floyd

3 months ago

I think the answer is A.

upvoted 0 times

...

Hannah

3 months ago

Hmm, I think it's B. All child objects without an explicit retention period will inherit the new one. Seems pretty straightforward.

upvoted 0 times

Samuel

1 months ago

I'm not sure, but I think it's D. Explicit child object retention periods will remain unchanged.

upvoted 0 times

...

Willodean

1 months ago

Actually, I think it's C. Child objects with an explicit retention period will be overridden with the new one.

upvoted 0 times

...

Marica

1 months ago

No, I believe it's B. Child objects without an explicit retention period will inherit the new one.

upvoted 0 times

...

Stevie

1 months ago

I think it's A. All child objects will retain data for the new retention period.

upvoted 0 times

...