Answer: Transient

The question asks for a Snowflake table type that is permanent (persists until explicitly dropped), accessible across sessions to all authorized users, and has no Fail-safe period. Transient tables (option D) meet all these criteria: they persist until explicitly dropped, are available to all users with appropriate privileges across sessions, and do not have a Fail-safe period (unlike permanent tables which have 7-day Fail-safe). Permanent tables (option B) have Fail-safe, temporary tables (option C) are session-scoped and not available across sessions, and external tables (option A) reference external data and have different persistence characteristics. The community discussion shows 100% consensus on D with upvoted comments confirming this is correct.

Author: LeetQuiz Editorial Team