Answer: Temporary

The question asks for a Snowflake table type that is: (1) only visible to the user who creates it, (2) can have the same name as permanent tables in the same schema, and (3) is dropped at the end of the session. According to Snowflake documentation and the community discussion consensus (with 100% agreement on A), temporary tables meet all these criteria. Temporary tables exist only within the session, are invisible to other users/sessions, can share names with permanent tables, and are automatically purged when the session ends. Option D (Transient) is incorrect because transient tables persist beyond the session until explicitly dropped and are visible to other users with appropriate privileges. Options B (Local) and C (User) are not valid Snowflake table types.

Author: LeetQuiz Editorial Team