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?

The correct answer is A. DATA_RETENTION_TIME_IN_DAYS. DATA_RETENTION_TIME_IN_DAYS is the Snowflake parameter that controls how long historical data is retained for Time Travel. When set at the account level, it defines the default retention period (0–90 days depending on edition) for all objects in the account. Individual…

Storage and Data Protection

Question

Options

ADATA_RETENTION_TIME_IN_DAYS
BMAX_DATA_EXTENSION_TIME_IN_DAYS
CMIN_DATA_RETENTION_TIME_IN_DAYS
DMAX CONCURRENCY LEVEL

How the community answered

(21 responses)

A
90% (19)
C
5% (1)
D
5% (1)

Explanation

DATA_RETENTION_TIME_IN_DAYS is the Snowflake parameter that controls how long historical data is retained for Time Travel. When set at the account level, it defines the default retention period (0–90 days depending on edition) for all objects in the account. Individual databases, schemas, or tables can override this, but the account-level value acts as the baseline. MAX_DATA_EXTENSION_TIME_IN_DAYS controls how long Snowflake can extend data retention to prevent streams from going stale - it does not set the Time Travel retention period. MIN_DATA_RETENTION_TIME_IN_DAYS is not a standard Snowflake parameter. MAX_CONCURRENCY_LEVEL controls query concurrency within a warehouse, unrelated to Time Travel.

Topics

#Time Travel#Data Retention#Account Parameters#Configuration

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice