Exam SOL-C01 Topic 2 Question 181 Discussion

Actual exam question for Snowflake's SOL-C01 exam
Question #: 181
Topic #: 2
A data scientist needs to create a temporary table in Snowflake to perform some data analysis.
The table should only be accessible within their current session and should be automatically dropped at the end of the session. Which of the following SQL statements is the CORRECT way to create such a table?

Suggested Answer: D Vote an answer

The 'CREATE TEMP TABLE statement is the correct way to create a temporary table in Snowflake that is only visible within the current session and is automatically dropped when the session ends. 'GLOBAL TEMPORARY TABLE' and 'LOCAL TEMPORARY TABLE' are not valid Snowflake syntax. 'CREATE TABLE without 'TEMP' creates a permanent table. 'VOLATILE applies to functions, not tables.

by Edwiin at Oct 14, 2026, 03:42 PM

Limited Time Offer

15%

Off

Get Premium SOL-C01 Questions as Interactive Self Test Engine or PDF

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
0
0
0
10