Exam SnowPro Core All QuestionsBrowse all questions from this exam
Go to Exam
Question 458

Which data types are valid in Snowflake? (Choose two.)

    Correct Answer: B, E

    Snowflake supports GEOGRAPHY as a geospatial data type, and VARIANT as a semi-structured data type. GEOGRAPHY allows for storage of geographic data, while VARIANT is used for storing heterogeneous data types, including semi-structured data such as JSON, XML, and Avro.

Discussion
AlexbDkuOptions: BE

B and E https://docs.snowflake.com/en/sql-reference/intro-summary-data-types.html#:~:text=structured%20Data%20Types-,VARIANT,-OBJECT

_yyuktaOptions: BE

BE are correct

e_l_i_a_sOptions: BE

Semi-structured Data Types: VARIANT OBJECT ARRAY Geospatial Data Types: GEOGRAPHY GEOMETRY https://docs.snowflake.com/en/sql-reference/intro-summary-data-types

MultiCloudIronManOptions: BE

https://docs.snowflake.com/en/sql-reference/intro-summary-data-types

EmiBOptions: BE

Snowflake does not support the following data types: BLOB, CLOB, ENUM Semi-structured Data Types: VARIANT, OBJECT, ARRAY - JSON are intended to be stored in here