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?
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?
DATA_RETENTION_TIME_IN_DAYS is the parameter that can be set at the account level to specify the number of days for which Snowflake retains historical data for Time Travel. This setting determines the duration for which you can access and query data from past states of tables within Snowflake.
MIN_DATA_RETENTION_TIME_IN_DAYS: Used to set the minimum data retention period for retaining historical data for Time Travel operations. https://docs.snowflake.com/en/sql-reference/parameters
The parameter that can be set at the account level to set the minimum number of days for which Snowflake retains historical data in Time Travel is A. DATA_RETENTION_TIME_IN_DAYS. This parameter allows you to specify how long Snowflake retains the historical data, enabling you to access and query data from past states of tables within the specified time frame.
Not quite. "MIN_DATA_RETENTION_TIME_IN_DAYS" is set at the account level. "DATA_RETENTION_TIME_IN_DAYS" is set at the object level (database, schema, table). the question is asking for the former, so the answer is C.
"Used to set the minimum data retention period for retaining historical data for Time Travel operations."
Maximum is set by default
C is correct, A is at object level the other two simply don't do that