20+ practice questions focused on Storage and Data Protection — one of the most tested topics on the SnowPro Advanced: Data Engineer exam. Each question includes a detailed explanation so you learn why the right answer is correct.
Start Storage and Data Protection PracticeA Data Engineer needs to ensure that a table containing sensitive PII can be restored to any point in time within the last 90 days. Which configuration must be applied to the table?
Explanation: To achieve 90 days of Time Travel, the DATA_RETENTION_TIME_IN_DAYS parameter must be explicitly set to 90 at the table level. By default, tables in the Standard Edition have 1 day, while Enterprise Edition has up to 90 days. Setting this allows the UNDROP command and time-travel queries to access data history for the full duration, ensuring compliance with strict data recovery requirements for sensitive datasets.
Which TWO statements are true regarding Snowflake Fail-safe?
Explanation: Fail-safe is a 7-day historical data protection period that occurs after the Time Travel window ends. It is designed to recover data in the event of a catastrophic system failure or data corruption. It cannot be configured by users, nor can it be accessed through standard SQL queries. Data in Fail-safe is only recoverable by Snowflake support, making it the final line of defense.
Which THREE actions can be performed on a table while it is in a state where it could be recovered via UNDROP?
Explanation: When a table is dropped, it enters a suspended state where it still exists in the metadata but is hidden from standard queries. While in this state, the table can be recovered using UNDROP. Furthermore, other objects in the same database can be created, dropped, or altered. The metadata associated with the table remains intact, allowing for schema operations and maintenance tasks to continue on the parent schema or database.
A Data Engineer is implementing a data lifecycle policy and needs to reduce storage costs. Which action will have the most immediate impact on reducing storage costs related to Time Travel?
Explanation: Storage costs for Time Travel are directly tied to the DATA_RETENTION_TIME_IN_DAYS parameter. Reducing this value decreases the amount of historical data maintained for that object. When this parameter is reduced, Snowflake initiates a background process to purge data that falls outside the new, shorter retention window, thereby freeing up storage and reducing associated monthly costs more effectively than other management tasks.
Which object type allows for the longest DATA_RETENTION_TIME_IN_DAYS setting in a Snowflake Standard Edition account?
Explanation: In Snowflake Standard Edition, the maximum retention period for any object is 1 day. This is a platform-wide restriction for that specific edition. While Enterprise and Business Critical editions allow up to 90 days, Standard Edition users are limited to 1 day for all tables, regardless of whether they are permanent or transient. This constraint is critical for architects planning disaster recovery strategies on lower-tier accounts.
+15 more Storage and Data Protection questions available
Practice all Storage and Data Protection questions1. Baseline your knowledge
Start with 10 questions to gauge your current understanding of Storage and Data Protection. This tells you whether you need a concept refresher or just practice.
2. Review every explanation
For each question — right or wrong — read the full explanation. Understanding why an answer is correct is more valuable than knowing the answer itself.
3. Focus on exam traps
Storage and Data Protection questions on the DEA-C02 frequently use trap wording. Look for subtle differences in answers that test your precision, not just general knowledge.
4. Reach 80% consistently
Do repeated sessions until you score 80%+ three times in a row. Then move to mixed-mode practice to test cross-topic recall under realistic conditions.
The exact number varies per candidate. Storage and Data Protection is tested as part of the SnowPro Advanced: Data Engineer blueprint. Practicing with targeted Storage and Data Protection questions ensures you can handle any format or difficulty that appears.
Yes. Courseiva provides free DEA-C02 practice questions across all exam topics and domains. The platform includes topic-based practice, mock exams, missed-question review, bookmarked questions, and readiness tracking — no account required.
Difficulty is subjective, but Storage and Data Protection is a high-priority exam concept tested in multiple ways — direct recall, scenario analysis, and command-output interpretation. Consistent practice is the best way to build confidence.
Launch a full Storage and Data Protection practice session with instant scoring and detailed explanations.
Start Storage and Data Protection Practice →