Exam SnowPro Core All QuestionsBrowse all questions from this exam
Question 963

Which Snowflake data type is used to store JSON key value pairs?

    Correct Answer: D

    The appropriate Snowflake data type for storing JSON key-value pairs is VARIANT. In Snowflake, the VARIANT data type is designed to store semi-structured data, including JSON. While the OBJECT data type can also store key-value pairs, VARIANT is more versatile as it can store values of different types, including arrays and other nested structures.

Discussion
0e504b5Option: D

D is correct https://docs.snowflake.com/en/sql-reference/data-types-semistructured VARIANT and OBJECT can contain key-value pairs