SnowPro Advanced: Data Engineer — Question 88

A table, mytable, is created using the following command in a schema called raw:

create table mytable(col1 number, col2 date) data_retention_time_in_days=90;

The DATA_RETENTION_TIME_IN_DAYS is set to 30 days for the raw schema.

If the raw schema gets dropped today, for how many days will the data in mytable be accessible through Time Travel?

Answer options

• A. 0 days
• B. 30 days
• C. 90 days
• D. 120 days

Correct answer: B

Explanation

The data retention time for the raw schema is 30 days, which overrides the 90 days set for mytable. Therefore, once the schema is dropped, the data will only be accessible for the duration of the schema's retention period, which is 30 days. The other options do not correctly reflect the retention period set by the schema.