Which data types does Snowflake support when querying semi-structured data? (Select TWO)

The correct answer is A. VARIANT: This is a universal data type that can store values of any other type, including B. ARRAY: An array is a list of elements that can be of any data type, including VARIANT, and is. Snowflake has three native semi-structured data types: VARIANT, OBJECT, and ARRAY. VARIANT (A) is a universal container type that can hold values of any data type-strings, numbers, booleans, arrays, objects, or null-making it the primary type used to store JSON, Avro, Parquet…

Snowflake Cloud Data Platform Features and Architecture

Question

Options

AVARIANT: This is a universal data type that can store values of any other type, including
BARRAY: An array is a list of elements that can be of any data type, including VARIANT, and is
CVARCHAR
DXML
EBLOB

How the community answered

(42 responses)

A
90% (38)
C
5% (2)
D
2% (1)
E
2% (1)

Explanation

Snowflake has three native semi-structured data types: VARIANT, OBJECT, and ARRAY. VARIANT (A) is a universal container type that can hold values of any data type-strings, numbers, booleans, arrays, objects, or null-making it the primary type used to store JSON, Avro, Parquet, ORC, and XML data after parsing. ARRAY (B) is a specialized semi-structured type representing an ordered list of VARIANT elements, used when the data is structured as a sequence. VARCHAR (C) is a standard structured string type and is not a semi-structured type. XML (D) can be ingested into Snowflake but is parsed and stored as VARIANT, not as a distinct semi-structured type. BLOB (E) is a binary large object type not natively supported as a semi-structured type in Snowflake.

Topics

#Semi-structured data#VARIANT data type#ARRAY data type#Snowflake data types

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice