SnowPro Core Certification — Question 85

Which type of table corresponds to a single Snowflake session?

Answer options

• A. Temporary
• B. Transient
• C. Provisional
• D. Permanent

Correct answer: A

Explanation

The correct answer is A, Temporary, as these tables exist only for the duration of the session and are automatically dropped at the end. Options B, C, and D do not fit the criteria since Transient tables persist beyond a session, Provisional is not a recognized type in Snowflake, and Permanent tables remain in the database until explicitly deleted.