Discover why Snowflake tables may be unrecoverable past 1 day despite database-level retention settings. Learn how schema DATA_RETENTION_TIME_IN_DAYS and TRANSIENT table type impact recovery.
Table of Contents
Question
A DevOps team has a requirement for recovery of staging tables used in a complex set of data pipelines. The staging tables are all located in the same staging schema. One of the requirements is to have online recovery of data on a rolling 7-day basis.
After setting up the DATA_RETENTION_TIME_IN_DAYS at the database level, certain tables remain unrecoverable past 1 day.
What would cause this to occur? (Choose two.)
A. The staging schema has not been setup for MANAGED ACCESS.
B. The DATA_RETENTION_TIME_IN_DAYS for the staging schema has been set to 1 day.
C. The tables exceed the 1 TB limit for data recovery.
D. The staging tables are of the TRANSIENT type.
E. The DevOps role should be granted ALLOW_RECOVERY privilege on the staging schema.
Answer
B. The DATA_RETENTION_TIME_IN_DAYS for the staging schema has been set to 1 day.
D. The staging tables are of the TRANSIENT type.
Explanation
The most likely causes for certain tables remaining unrecoverable past 1 day despite setting DATA_RETENTION_TIME_IN_DAYS at the database level are:
B. The DATA_RETENTION_TIME_IN_DAYS for the staging schema has been set to 1 day, overriding the database-level setting for tables in that schema.
D. The staging tables are of the TRANSIENT type, which do not support Time Travel and have a fixed retention period of only 1 day.
Setting MANAGED ACCESS on the schema or granting ALLOW_RECOVERY privilege would not impact the recoverability of tables with these specific schema- or table-level configurations that limit retention to 1 day. The 1 TB limit does not apply to Time Travel recovery.
Snowflake SnowPro Advanced Architect certification exam practice question and answer (Q&A) dump with detail explanation and reference available free, helpful to pass the Snowflake SnowPro Advanced Architect exam and earn Snowflake SnowPro Advanced Architect certification.