DEA-C02 Storage and Data Protection Practice Question

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

• ✗

  All data from the last 5 days becomes immediately accessible.

  Why it's wrong here

  Changing the parameter does not magically recover data that was already purged. If the retention was 1 day, data older than 24 hours has already been permanently cleaned up by background processes. Only data that exists from the time of the change will be kept for the new 5-day window.

• ✓

  The table begins retaining historical data for 5 days moving forward.

  Why this is correct

  Increasing the retention setting tells Snowflake to hold onto data versions for the new, longer period starting from the time the parameter is updated. This allows for a longer Time Travel window for future data states, supporting the requirement to access historical data for analysis or recovery operations.

• ✗

  The storage cost remains the same as it was.

  Why it's wrong here

  Increasing retention will inevitably increase storage costs over time. By holding more historical versions of data, the amount of data occupied on disk grows. Users must account for this increased storage footprint when extending retention, as it directly impacts monthly costs for the specific table and database.

• ✗

  The change takes effect only after the next vacuum process.

  Why it's wrong here

  Snowflake does not have a manual 'vacuum' process. The configuration change updates the metadata immediately, and the background storage management system adjusts its behavior accordingly. The new retention policy is applied as soon as the ALTER TABLE command finishes, ensuring the update is effective without manual intervention.