Exam SnowPro Core topic 1 question 100 discussion

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)

D.Table

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

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.

D 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.

A is correct

D. Table [ALTER TABLE t SET DATA_RETENTION_TIME_IN_DAYS = 0;]

Dear Admin most granular means lowest now here answer would be table. Pls correct the answers

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.

Answer: Table

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.