DEA-C02 Storage and Data Protection Practice Question
A data engineer is reviewing storage costs in a Snowflake account. The engineer notices that a permanent table named CUSTOMER_DIM has a DATA_RETENTION_TIME_IN_DAYS value of 90, but the account is on Standard Edition. The engineer wants to confirm whether this is valid. What is the maximum Time Travel retention period for a permanent table in a Standard Edition account?
⚠ Common exam trap
The trap here is conflating Fail-safe's fixed 7-day period with the Time Travel maximum, when Standard Edition Time Travel is capped at 1 day.
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 day
On Standard Edition, permanent tables support a maximum Time Travel retention of 1 day, with 0 disabling Time Travel entirely. Longer retention periods such as 7 or 90 days require Enterprise Edition or higher. A 90-day setting in a Standard Edition account is therefore invalid, and the engineer should expect the maximum to be 1 day.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
1 day
Why this is correct
Standard Edition supports a maximum Time Travel retention of 1 day for permanent tables. The default is 1 day, and it can be set to 0 to disable Time Travel. Values above 1 day, such as 90, require Enterprise Edition or higher. This is why a 90-day setting is invalid on Standard Edition and must be corrected or the account upgraded.
- ✗
90 days
Why it's wrong here
Ninety days is the maximum Time Travel retention available on Enterprise Edition and higher for permanent tables, not Standard Edition. On Standard Edition, attempting to set 90 days is not allowed. This option reflects the Enterprise Edition limit, which does not apply in a Standard Edition account, so it cannot be the correct maximum here.
- ✗
0 days
Why it's wrong here
Zero days means Time Travel is disabled, which is a valid setting but not the maximum retention. The question asks for the longest allowed retention, and Standard Edition permits up to 1 day. Setting 0 removes recovery ability entirely, so it cannot represent the maximum. This option confuses the minimum/disabled state with the upper limit.
- ✗
7 days
Why it's wrong here
Seven days corresponds to the Fail-safe period that follows Time Travel, not the Standard Edition Time Travel maximum. Fail-safe is non-configurable and not user-accessible. Confusing Fail-safe's 7-day duration with the Time Travel retention limit leads to this incorrect choice. Standard Edition permanent tables are limited to 1 day of Time Travel, not 7.
About these practice questions
Courseiva writes every DEA-C02 question from scratch — 229 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or 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.