Exam COF-C03 Topic 3 Question 822 Discussion

Actual exam question for Snowflake's COF-C03 exam
Question #: 822
Topic #: 3
The data retention time for a schema is set to 5 days, and the data retention time for the database containing the schema is set to 10 days.
Based on these settings, what would be the default data retention time for a permanent table created in the schema?

Suggested Answer: C Vote an answer

The DATA_RETENTION_TIME_IN_DAYS parameter can be set at account, database, schema, or supported object levels. When a table does not explicitly set its own retention period, it inherits the applicable value from its nearest parent container. In this scenario, the database has a 10-day setting, but the schema inside that database has a more specific 5-day setting. A permanent table created in that schema therefore inherits five days, not the database's ten days. An account-level MIN_DATA_RETENTION_TIME_IN_DAYS value could raise the effective retention period if it were configured, but no such setting is stated in the question. Because retention longer than one day requires Enterprise Edition or higher, the scenario also assumes an edition supporting extended Time Travel.
The correct answer is C.

by queen at Aug 06, 2026, 01:45 AM

Limited Time Offer

15%

Off

Get Premium COF-C03 Questions as Interactive Self Test Engine or PDF

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
queen
2026-08-06 01:45:05
Selected Answer: C
When you create a new table without explicitly setting DATA_RETENTION_TIME_IN_DAYS, it inherits the value from its parent schema, not directly from the database.

Snowflake uses parameter inheritance:
Account → Database → Schema → Table
upvoted 1 times
...
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
0
0
0
10