Answer: Transient table

According to Snowflake best practices, transient tables (option C) are recommended when data can be recreated outside of Snowflake. Transient tables exist until explicitly dropped and do not have Fail-safe protection, with a maximum Time Travel retention period of 1 day. This provides significant storage cost savings compared to permanent tables, while temporary tables (option B) are session-scoped and would not persist beyond the current session, making them unsuitable for data that needs to be retained across sessions. The community discussion strongly supports option C with 100% consensus, highlighting the cost benefits and appropriate use case for transient tables when data is recreatable externally.

Author: LeetQuiz Editorial Team