Answer: Temporary, Transient

In Snowflake, Fail-safe is a data protection feature that provides a 7-day period after the Time Travel retention period ends, during which data is recoverable by Snowflake support. However, this feature is not available on Temporary and Transient tables. Temporary tables exist only for the duration of the session and are automatically dropped, while Transient tables are designed for temporary data that doesn't require the same level of data protection as Permanent tables. Both Temporary (A) and Transient (B) tables lack Fail-safe protection to reduce storage costs and complexity for transient data. Option C (Provisional) is not a valid Snowflake table type, and Option D (Permanent) tables do have Fail-safe enabled by default, making them unsuitable answers.

Author: LeetQuiz Editorial Team