Users are responsible for data storage costs until what occurs?

The correct answer is B. Data expires from Fail-safe. When data is deleted in Snowflake, it passes through two retention phases before being fully purged. First, it enters Time Travel (up to 90 days, configurable), where users can query or restore it. After Time Travel expires, data moves into Fail-safe (a fixed 7-day period for…

Storage and Data Protection

Question

Options

AData expires from Time Travel
BData expires from Fail-safe
CData is deleted from a table
DData is truncated from a table

How the community answered

(29 responses)

A
3% (1)
B
93% (27)
D
3% (1)

Explanation

When data is deleted in Snowflake, it passes through two retention phases before being fully purged. First, it enters Time Travel (up to 90 days, configurable), where users can query or restore it. After Time Travel expires, data moves into Fail-safe (a fixed 7-day period for permanent tables), which is a disaster-recovery mechanism managed by Snowflake. Storage costs are charged for data in both Time Travel and Fail-safe. Only after the Fail-safe period ends is the data physically removed and storage costs cease. Simply deleting or truncating a table does not immediately eliminate storage charges.

Topics

#Storage costs#Fail-safe#Data retention#Billing

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice