SnowPro Core Certification — Question 974

A user created a database and set the DATA_RETENTION_TIME_IN_DAYS to 30, but did not set the DATA_RETENTION_TIME_IN_DAYS in table T1. After 5 days, the user accidentally drops table T1.

What are the considerations for recovering table T1?

Answer options

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

Correct answer: B

Explanation

The correct answer is B because the table T1 inherits the DATA_RETENTION_TIME_IN_DAYS setting from the database, allowing it to be recovered within that timeframe. Answer A is incorrect because recovery is possible before 30 days, C is wrong since contacting support is not necessary under these conditions, and D is incorrect as the table's retention setting defaults to that of the database.