Which type of table corresponds to a single Snowflake session?

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.

Snowflake Overview and Architecture

Question

Options

ATemporary
BTranslent
CProvisional
DPermanent

How the community answered

(23 responses)

A
78% (18)
B
13% (3)
C
4% (1)
D
4% (1)

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.

Topics

#temporary tables#table types#session scope

Community Discussion

No community discussion yet for this question.

Full COF-R02 Practice