What is the MAXIMUM size limit for a record of a VARIANT data type?

The correct answer is B. 16MB. Snowflake's VARIANT data type is used to store semi-structured data such as JSON, Avro, ORC, Parquet, or XML. The maximum size for a single VARIANT value is 16MB (compressed). If a VARIANT value exceeds this limit, Snowflake will return an error during loading or insertion…

Snowflake Cloud Data Platform Features and Architecture

Question

Options

A8MB
B16MB
C32MB
D128MB

How the community answered

(47 responses)

A
4% (2)
B
94% (44)
C
2% (1)

Explanation

Snowflake's VARIANT data type is used to store semi-structured data such as JSON, Avro, ORC, Parquet, or XML. The maximum size for a single VARIANT value is 16MB (compressed). If a VARIANT value exceeds this limit, Snowflake will return an error during loading or insertion. This limit applies per individual VARIANT column value, not per row.

Topics

#VARIANT data type#Data type limits#Semi-structured data#Snowflake data types

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice