Answer: Temporary

The question asks about a table type that is automatically deleted after a session is closed and has no Fail-safe or Time Travel costs. In Snowflake, temporary tables are session-scoped and are automatically dropped at the end of the session. They do not incur Fail-safe or Time Travel costs, which aligns with the question's requirements. Option B (Transient) is incorrect because transient tables are not automatically deleted after a session ends; they persist until explicitly dropped and do not have Fail-safe but still have Time Travel (though limited). Option C (Permanent) is incorrect as permanent tables are persistent and have both Fail-safe and Time Travel costs. Option D (External) is incorrect because external tables reference data outside Snowflake and are not automatically deleted after a session. The community discussion unanimously supports A (Temporary) with 100% agreement and upvoted comments, confirming it as the correct choice.

Author: LeetQuiz Editorial Team