Learn about the MIN_DATA_RETENTION_TIME_IN_DAYS parameter in Snowflake and the level at which it is set. Discover how this parameter affects data retention in your Snowflake account.
Table of Contents
Question
At what level is the MIN_DATA_RETENTION_TIME_IN_DAYS parameter set?
A. Account
B. Database
C. Schema
D. Table
Answer
The MIN_DATA_RETENTION_TIME_IN_DAYS parameter in Snowflake is set at the Account level (Option A).
Explanation
The MIN_DATA_RETENTION_TIME_IN_DAYS parameter is an important setting in Snowflake that determines the minimum number of days that data is retained in Time Travel and Fail-safe before it is permanently deleted. This parameter is set at the account level, meaning it applies to all databases, schemas, and tables within the Snowflake account.
When you set the MIN_DATA_RETENTION_TIME_IN_DAYS parameter at the account level, it enforces a minimum retention period for all objects in the account. This ensures that data is not deleted prematurely and remains available for the specified number of days, even if individual objects have a shorter retention period set.
It’s important to note that setting this parameter at the account level provides a global control over data retention. While you can set retention periods at lower levels (e.g., database, schema, or table), the account-level MIN_DATA_RETENTION_TIME_IN_DAYS takes precedence and ensures a minimum retention period across the entire account.
By understanding that the MIN_DATA_RETENTION_TIME_IN_DAYS parameter is set at the account level, you can effectively manage data retention policies in your Snowflake environment and ensure that critical data is retained for the required duration.
Snowflake SnowPro Core Recertification certification exam assessment practice question and answer (Q&A) dump including multiple choice questions (MCQ) and objective type questions, with detail explanation and reference available free, helpful to pass the Snowflake SnowPro Core Recertification exam and earn Snowflake SnowPro Core Recertification certification.