Which Snowflake table supports unstructured data?

The correct answer is D. Permanent. Permanent tables are the standard, full-featured Snowflake table type and support all data formats including unstructured and semi-structured data (via VARIANT, OBJECT, and ARRAY column types). Temporary tables are session-scoped and dropped at session end; transient tables…

Storage and Data Protection

Question

Options

ADirectory
BTransient
CTemporary
DPermanent

How the community answered

(32 responses)

A
3% (1)
C
3% (1)
D
94% (30)

Explanation

Permanent tables are the standard, full-featured Snowflake table type and support all data formats including unstructured and semi-structured data (via VARIANT, OBJECT, and ARRAY column types). Temporary tables are session-scoped and dropped at session end; transient tables lack Fail-safe protection and have limited Time Travel; 'Directory' is not a standard Snowflake table creation type - directory tables are metadata overlays on stages used to catalog files, not a standalone table category you define with CREATE TABLE.

Topics

#Unstructured Data#Permanent Table#Table Types#Data Storage

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice