Answer: Fail-safe

In Snowflake, transient tables do not have a Fail-safe period, which is a 7-day period where data is recoverable after it has been dropped or updated in permanent tables. This Fail-safe storage incurs costs for permanent tables but is completely eliminated for transient tables. The community discussion confirms this with a reference to Snowflake documentation showing that B (Fail-safe) is the correct answer. Other options are incorrect: Active refers to current data storage which still exists for transient tables, Staged is not a Snowflake storage cost type, and Time Travel is a separate feature that transient tables still have (though with a shorter 1-day retention vs 1-90 days for permanent tables).

Author: LeetQuiz Editorial Team