Answer: Transient table

The question asks for a Snowflake storage object that persists data beyond a single session and does not incur Fail-safe costs. Transient tables (D) meet both criteria: they persist data beyond the current session (unlike temporary tables) and do not have Fail-safe protection, thus avoiding Fail-safe costs. Permanent tables (A) persist data but incur Fail-safe costs. External tables (B) store metadata in Snowflake but data externally, so Fail-safe doesn't apply, but they are not primarily for storing data within Snowflake. Temporary tables (C) do not persist beyond the session. The community discussion unanimously supports D with 100% agreement and references to Snowflake documentation on storage costs, confirming transient tables as the correct choice.

Author: LeetQuiz Editorial Team