Snowflake SnowPro Core
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
A user created a database with DATA_RETENTION_TIME_IN_DAYS set to 30 but did not explicitly set DATA_RETENTION_TIME_IN_DAYS for table T1. After 5 days, the user accidentally drops table T1.
What are the considerations for recovering table T1?
A
The user can recover the table T1 after 30 days.
B
The table can be recovered because the table retention period default is at the database level.
C
The table can only be recovered by contacting Snowflake Support to recover the table from Fail-safe.
D
The table cannot be recovered because the DATA_RETENTION_TIME_IN_DAYS was not set for table T1.