COF-R02 Question #8: Real Exam Question with Answer & Explanation

The correct answer is A. Temporary. Snowflake supports creating temporary tables for storing non-permanent, transitory data (e.g. ETL data, session-specific data). Temporary tables only exist within the session in which they were created and persist only for the remainder of the session.

Question

Which type of table corresponds to a single Snowflake session?

Options

ATemporary
BTranslent
CProvisional
DPermanent

Explanation

Snowflake supports creating temporary tables for storing non-permanent, transitory data (e.g. ETL data, session-specific data). Temporary tables only exist within the session in which they were created and persist only for the remainder of the session.

Community Discussion

No community discussion yet for this question.

Full COF-R02 Practice