SnowPro Advanced: Architect — Question 133

Database DB1 has schema S1 which has one table, T1:

DB1 --> S1 --> T1 -

The retention period of DB1 is set to 10 days.
The retention period of S1 is set to 20 days.
The retention period of T1 is set to 30 days.

The user runs the following command:

Drop Database DB1;

What will the Time Travel retention period be for T1?

Answer options

Correct answer: A

Explanation

The Time Travel retention period for T1 will be 10 days because the retention period of the database DB1 takes precedence and is shorter than the retention periods of both S1 and T1. Once DB1 is dropped, the entire schema and its tables are no longer accessible beyond the database's retention period.