ExamGecko
Question list
Search
Search

Question 552 - SnowPro Core discussion

Report
Export

Which data types can be used in a Snowflake table that holds semi-structured data? (Select TWO).

A.

ARRAY

Answers
A.

ARRAY

B.

BINARY

Answers
B.

BINARY

C.

TEXT

Answers
C.

TEXT

D.

VARIANT

Answers
D.

VARIANT

E.

VARCHAK

Answers
E.

VARCHAK

Suggested answer: A, D

Explanation:

Snowflake supports semi-structured data types that can store complex data structures within a single column. The VARIANT data type can hold structured and semi-structured data formats such as JSON, Avro, ORC, Parquet, and XML. The ARRAY data type is also used for semi-structured data and can store an ordered list of elements. These data types enable users to work with semi-structured data directly in Snowflake without needing to flatten the data into a relational schema first.

Reference: Snowflake Documentation on Semi-Structured Data Types

asked 29/10/2024
Craig Reid
36 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first