Database XYZ has the data_retention_time_in_days parameter set to 7 days and table XYZ.public.ABC has the data_retention_time_in_days set to 10 days.
A Developer accidentally dropped the database containing this single table 8 days ago and just discovered the mistake.
How can the table be recovered?
When a database is dropped, Snowflake's Fail-safe feature can be used to recover it within a specified retention period. Since the database was dropped 8 days ago, and surpasses the data retention period of 7 days for the database but within 10 days for the table, the mechanics of Snowflake would mean that the Fail-safe period would be required. Creating a Snowflake Support case to restore the database and table from Fail-safe is the correct approach.
I think D, the retention period for the table although longer should not be honored when dropping the DB, the table should have been dropped first
A.Snowflake does not provide a direct undrop command for databases or tables. B.The at (offset => -60*60*24*8) syntax is not a valid way to recover dropped tables in Snowflake. The at clause is used for temporal queries, and it doesn't have the capability to recover dropped tables. C.However, it does not have the ability to recover dropped tables. The at (offset => -3600*24*8) part is not a valid syntax for recovering dropped tables. D. Create a Snowflake Support case to restore the database and table from Fail-safe. This is the correct option. Snowflake's Fail-safe feature is designed for recovering dropped tables or databases within a specified retention period. By creating a support case, you can request assistance from Snowflake support to restore the dropped database and table from Fail-safe, ensuring data recovery within the allowed retention time.
Just like Snow_P said, D is the correct answer. https://docs.snowflake.com/en/user-guide/data-time-travel#dropped-containers-and-object-retention-inheritance