DEA-C02 Question #112: Real Exam Question with Answer & Explanation

Question

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?

Options

• A0 days
• B30 days
• C90 days
• D120 days

Explanation

When a schema is dropped in Snowflake, the schema's own DATA_RETENTION_TIME_IN_DAYS (30 days) governs how long the dropped schema - and everything inside it - remains accessible via Time Travel, because child objects (like mytable) can only be reached by first undropping the parent schema. The table's 90-day setting (option C) is irrelevant here: it would apply if the table were dropped independently, but since the schema was dropped, the schema's shorter retention period acts as the ceiling. Option A (0 days) is wrong because dropping a schema does not immediately purge data - it enters Time Travel per the schema's retention. Option D (120 days) is a trap that implies adding both retention values together, which Snowflake never does.

Memory tip: Think of it as a locked box - the schema is the box, and the table is inside it. If the box is thrown away (dropped with 30-day retention), it doesn't matter that the item inside had a 90-day tag; you only have as long as the box is retrievable to get back inside.

No community discussion yet for this question.