Answer: Temporary

The question asks about a table type that is not retained after the session ends and lacks Fail-safe and Time Travel recovery options. In Snowflake, Temporary tables (option C) are session-scoped and are automatically dropped at the end of the session, meaning they do not support Fail-safe or Time Travel. This aligns with Snowflake documentation and the community consensus, where 86% of users selected C, and multiple comments with upvotes confirm C as correct. Option D (Transient) is incorrect because Transient tables persist beyond the session and do support Time Travel (though not Fail-safe). Options A (External) and B (Permanent) are also incorrect as they persist and support these features.

Author: LeetQuiz Editorial Team