SnowPro Core Certification — Question 586

Which Snowflake table type is only visible to the user who creates it, can have the same name as permanent tables in the same schema, and is dropped at the end of the session?

Answer options

• A. Temporary
• B. Local
• C. User
• D. Transient

Correct answer: A

Explanation

The correct answer is A, Temporary, as it is designed for use within a single session and is not visible to other users. Options B, C, and D do not meet all the criteria specified: Local does not pertain to visibility, User is not a recognized table type, and Transient tables persist beyond the session.