What is the passing score for the Snowflake SnowPro Core exam?

The SnowPro Core (COF-C03) certification exam passing score is 750 or higher on a scaled score range of 0 to 1000.

Is CloudPrep affiliated with Snowflake Inc.?

No. Snowflake® and SnowPro® are registered trademarks of Snowflake Inc. CloudPrep is an independent educational platform and is not affiliated with, sponsored by, or endorsed by Snowflake Inc.

What is the maximum Time Travel retention period for a permanent table in Snowflake Enterprise Edition?

90 days — Snowflake Enterprise Edition (and higher) allows up to 90 days of Time Travel for permanent tables. Standard edition only allows 1 day.

A data engineer drops a temporary table in Snowflake Enterprise Edition. What is the maximum Time Travel retention period they could have configured for this table?

1 day — For transient and temporary tables, the maximum Time Travel retention period is 1 day, regardless of the Snowflake edition.

How long is the Fail-safe period for permanent tables in Snowflake?

7 days — Fail-safe provides a non-configurable 7-day period for data recovery after the Time Travel retention period ends, strictly for permanent tables.

Domain: Supplementary Concepts & Tools (Pro Study Module)

September 2026 · 470 words · 10 min read

Time Travel & Fail-safe

Overview

Time Travel and Fail-safe are critical Snowflake features for data protection, enabling recovery from accidental data loss, table drops, and corruption without manual backups. They are heavily tested on the SnowPro Core exam.

Key Concepts

Time Travel

Enables accessing historical data (i.e., data that has been changed or deleted) at any point within a specified period.

Fail-safe

Unlock Full Deep-Dive Guide & 14 Practice MCQs

This complete architectural module, full checkpoint quiz, and unlimited mock exam simulations are included with the CloudPrep Pro Pass.

Unlock with Pro Pass