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.

• ✗

  Standard Edition.

  Why it's wrong here

  Standard Edition is limited to a 1-day retention period for all tables. It does not support the 90-day Time Travel requirement. This edition is intended for workloads where short-term recovery is sufficient, and it lacks the advanced data protection features found in higher-tier editions like Enterprise or Business Critical.

• ✓

  Enterprise Edition.

  Why this is correct

  Enterprise Edition and higher (including Business Critical) are specifically designed to support long-term Time Travel up to 90 days. This capability allows organizations to meet rigorous compliance and historical data access requirements that are not achievable within the standard 1-day retention limit of the entry-level edition.

• ✗

  Any edition supports 90 days by default.

  Why it's wrong here

  Not all editions support a 90-day retention period. The Standard Edition is strictly capped at 1 day. Assuming all editions support 90 days would lead to incorrect architectural decisions. Understanding the limitations of each Snowflake edition is mandatory for correctly configuring data protection policies for production environments.

• ✗

  Only the Trial Edition.

  Why it's wrong here

  The Trial Edition is generally equivalent to the Enterprise Edition but does not inherently change the platform's constraints. 90-day retention is an Enterprise-level feature. Claiming it is 'only' available in the Trial version is factually incorrect, as it is a standard feature for paid Enterprise and Business Critical customers.