DEA-C02 Storage and Data Protection Practice Question
A data engineer is configuring a new permanent table in a Snowflake Standard Edition account. The engineer needs to ensure that the table can be recovered if it is accidentally dropped, but wants to minimize storage costs. The table will be updated frequently. Which DATA_RETENTION_TIME_IN_DAYS setting should the engineer choose to meet these requirements?
⚠ Common exam trap
The trap here is assuming that longer retention periods are available in Standard Edition, when in fact they are limited to 1 day for permanent tables.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
1
In Snowflake Standard Edition, permanent tables can have a maximum Time Travel retention of 1 day. To enable recovery of a dropped table while minimizing storage costs, the engineer should set DATA_RETENTION_TIME_IN_DAYS to 1. This provides a 1-day window for recovery and keeps Time Travel storage overhead to a minimum.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
0
Why it's wrong here
Setting DATA_RETENTION_TIME_IN_DAYS to 0 disables Time Travel for the table. While this minimizes storage costs, it also means the table cannot be recovered if dropped. The requirement is to recover the table if accidentally dropped, so Time Travel must be enabled. A setting of 0 does not meet the recovery requirement.
- ✗
7
Why it's wrong here
A retention period of 7 days is not supported for permanent tables in Snowflake Standard Edition. Standard Edition allows 0 or 1 day for permanent tables. Setting it to 7 would result in an error or be automatically reduced to 1. While 7 days would provide a longer recovery window, it is not a valid configuration for this edition, so it cannot be chosen.
- ✓
1
Why this is correct
In Snowflake Standard Edition, the maximum Time Travel retention for permanent tables is 1 day. Setting DATA_RETENTION_TIME_IN_DAYS to 1 enables recovery of the table if it is dropped within that 1-day period. This is the minimum setting that provides recovery capability while keeping storage costs low. It meets the requirement to recover the table and minimizes storage overhead.
- ✗
90
Why it's wrong here
90 days is the maximum retention for permanent tables in Snowflake Enterprise Edition, not Standard Edition. Standard Edition only supports 0 or 1 day. Choosing 90 would not be allowed and would not minimize storage costs. The requirement is to minimize storage costs, so a longer retention period would increase storage usage for Time Travel data.
About these practice questions
This DEA-C02 question is part of Courseiva's 229-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Snowflake exam blueprint
This DEA-C02 practice question is part of Courseiva's free Snowflake certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DEA-C02 exam.