COF-C03: SnowPro Core Certification

By Snowflake · Question Mode

QuestionQ45

Account Management & Data Governance

A schema has its data retention time set to 5 days, while the database that contains that schema has its data retention time set to 10 days.

Based on these settings, what is the default data retention time for a permanent table created in the schema?

Explanation

A schema-level DATA_RETENTION_TIME_IN_DAYS setting is inherited by default by tables created in that schema. Therefore, a permanent table created there has a 5-day default retention period; the schema setting takes precedence over the database-level default.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!