What is the most granular object that the Time Travel retention period can be defined on?
What is the most granular object that the Time Travel retention period can be defined on?
The most granular object that the Time Travel retention period can be defined on is the table. In database management, 'granular' refers to the level of detail at which something can be managed. Since tables are the fundamental units where data is stored, they offer the highest level of granularity for setting specific parameters such as the Time Travel retention period.
The time travel data retention can be overwritten at the table level "When creating a table, schema, or database, the account default can be overridden using the DATA_RETENTION_TIME_IN_DAYS parameter in the command."
Granular is Table. It is the most granular object not account. Account--database --schema-- table(most granular)
To specify the data retention period for Time Travel: The DATA_RETENTION_TIME_IN_DAYS object parameter can be used by users with the ACCOUNTADMIN role to set the default retention period for your account. The same parameter can be used to explicitly override the default when creating a database, schema, and individual table. The data retention period for a database, schema, or table can be changed at any time.
Answer: Table
Table is most granular
D is correct answer, at the lowest granular level object time travel can be configured.
D is correct answer, at the lowest granular level object time travel can be configured.
Dear Admin most granular means lowest now here answer would be table. Pls correct the answers
D. Table [ALTER TABLE t SET DATA_RETENTION_TIME_IN_DAYS = 0;]
A is correct
Most granular means with the highest level of detail, where do we obtain that? Of course in the table, the account contains a low level of detail, answer is D.
D is correct
High granularity level refers to a high level of detail, vice-versa low granularity level refers to a low level of detail. Practically speaking, the more subdividable and specific a data is, the more granular it is considered to be. Thus, “granularity” and “level of detail” of data are the same thing. In this case the most granular level is asked and that is a syntactic issue as most is defined by the perspective. Highest or Lowest level So both A and D could be correct. However I think that Most is meant als the highest level of detail and that would be D.
The Time Travel retention period in Snowflake specifies the number of days for which historical data is preserved and, therefore, Time Travel operations (SELECT, CREATE … CLONE, UNDROP) can be performed on the data 1. The standard retention period is 1 day (24 hours) and is automatically enabled for all Snowflake accounts 1. For Snowflake Enterprise Edition (and higher), the retention period can be set to any value from 0 up to 90 days for permanent databases, schemas, and tables 12. Therefore, the most granular object that the Time Travel retention period can be defined on is a table 1. I hope this helps! https://docs.snowflake.com/en/user-guide/data-time-travel
D.Table