Answer: Temporary

The question asks which type of table corresponds to a single Snowflake session. According to Snowflake documentation and the community discussion with strong consensus (100% of answers and multiple upvoted comments), temporary tables are session-specific. Temporary tables exist only within the session where they are created and are automatically dropped when the session ends. Transient tables (B) persist until explicitly dropped and are not session-specific. Provisional (C) is not a valid Snowflake table type. Permanent tables (D) are the default persistent tables. The community references and documentation links confirm that temporary tables are the correct answer for session-specific tables.

Author: LeetQuiz Editorial Team