COF-C02 Question #581: Real Exam Question with Answer & Explanation

The correct answer is A: Temporary. 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 tra

Snowflake Cloud Data Platform Features and Architecture

Question

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?

Options

ATemporary
BLocal
CUser
DTransient

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.

Topics

#Snowflake table types#Temporary tables#Session-scoped objects#Table lifecycle

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice Browse All COF-C02 Questions