SnowPro Core (COF-C03) · Free practice question 4 of 15
Snowflake edition for extended Time Travel
An organization needs Time Travel retention greater than 1 day on production tables. What is the MINIMUM Snowflake edition required to enable this?
- A.Standard
- B.Enterprise
- C.Business Critical
- D.Virtual Private Snowflake (VPS)
Show answer and explanation
Correct answer: B. Enterprise
Why: Standard edition supports up to 1 day of Time Travel. Enterprise adds up to 90 days on permanent tables — that's the minimum edition where extended Time Travel is available. Business Critical adds additional encryption and HIPAA/PCI features; VPS provides a dedicated tenant. For extended Time Travel alone, Enterprise is enough.
More free SnowPro Core (COF-C03) questions
- Micro-partition immutability
- SECURITYADMIN for user and role management
- Multi-cluster warehouses for concurrency
- Recovering a truncated table with Time Travel
- Types of internal stages
- File sizing for COPY INTO
- Query result cache
- Reader accounts for non-Snowflake consumers
- LATERAL FLATTEN on VARIANT arrays
- Streams and tasks for change data capture
- Clustering keys for partition pruning
- Network policies for IP allowlisting
- Zero-copy cloning for QA environments
- Snowpipe auto-ingest for low latency