
Ultimate access to all questions.
At which level can the Time Travel retention period be set with the finest granularity?
A
Account
B
Database
C
Schema
D
Table
Explanation:
The question asks for the most granular object where Time Travel retention period can be defined. In Snowflake's hierarchy (Account → Database → Schema → Table), the table is the most granular/fine-grained level. The community discussion strongly supports this with 95% selecting D (Table), and multiple comments citing Snowflake documentation confirming that DATA_RETENTION_TIME_IN_DAYS can be set at the table level, providing the finest granular control. While the parameter can be set at account, database, and schema levels, table-level configuration offers the most specific control, making D the correct answer.