
Answer-first summary for fast verification
Answer: VARIANT
The VARIANT data type in Snowflake is specifically designed to store semi-structured data and can accommodate multiple data structures including arrays, objects, and various data types within a single column. This makes it the correct choice for storing more than one type of data structure. JSON (A) is not a Snowflake data type but a data format that can be stored in VARIANT. BINARY (B) stores binary data only. VARCHAR (C) stores string data only. The community discussion shows 100% consensus on D (VARIANT) with multiple users confirming this answer and upvotes supporting the selection.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.