ExamGecko
Question list
Search
Search

Question 597 - SnowPro Core discussion

Report
Export

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?

A.

Temporary

Answers
A.

Temporary

B.

Local

Answers
B.

Local

C.

User

Answers
C.

User

D.

Transient

Answers
D.

Transient

Suggested answer: A

Explanation:

In Snowflake, a Temporary table is a type of table that is only visible to the user who creates it, can have the same name as permanent tables in the same schema, and is automatically dropped at the end of the session in which it was created. Temporary tables are designed for transient data processing needs, where data is needed for the duration of a specific task or session but not beyond. Since they are automatically cleaned up at the end of the session, they help manage storage usage efficiently and ensure that sensitive data is not inadvertently persisted.

Snowflake Documentation on Temporary Tables: Temporary Tables

asked 29/10/2024
Avadhesh Dubey
32 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first