Which Snowflake data types can be used to build nested hierarchical data? (Choose two.)
Which Snowflake data types can be used to build nested hierarchical data? (Choose two.)
To build nested hierarchical data in Snowflake, the OBJECT and VARIANT data types are suitable. OBJECT can store key-value pairs, allowing nested structures, while VARIANT can hold a value of any type, including other VARIANTs, OBJECTs, or even ARRAYS, making it versatile for hierarchical data.
B and C is right. A VARIANT can hold a value of any other data type, including an ARRAY or an OBJECT. An ARRAY or OBJECT holds a value of type VARIANT.
You can use Snowflake data types to construct a hierarchy to hold your semi-structured data by using the following properties of data types: 1. A VARIANT can hold a value of any other data type, including an ARRAY or an OBJECT. 2. An ARRAY or OBJECT holds a value of type VARIANT.
B & C https://docs.snowflake.com/en/user-guide/semistructured-intro#:~:text=The%20ARRAY%2C%20OBJECT%2C%20and%20VARIANT,store%20it%20in%20a%20VARIANT.