Answer: Data expires from Fail-safe

The correct answer is B because data storage costs continue until data expires from Fail-safe. According to Snowflake documentation and the community discussion with the highest consensus (67% for B), storage is charged for data in Active, Time Travel, and Fail-safe states. The data lifecycle is sequential: Active → Time Travel (0-90 days) → Fail-safe (7 days). Costs are incurred until data leaves Fail-safe, not when it expires from Time Travel (A), as Time Travel is followed by Fail-safe. Deleting (C) or truncating (D) data moves it to Time Travel and then Fail-safe, so costs continue; permanent deletion occurs only after Fail-safe expiration.

Author: LeetQuiz Editorial Team