
Answer-first summary for fast verification
Answer: BINARY, VARCHAR
The question asks for the recommended alternative data types in Snowflake for unsupported large object types BLOB and CLOB. According to Snowflake documentation and the community discussion (with 100% consensus on CE), BINARY is the recommended alternative for BLOB data, and VARCHAR is the recommended alternative for CLOB data. The other options are not suitable: VARIANT is for semi-structured data, ARRAY is for ordered lists, and OBJECT is for key-value pairs, none of which serve as direct replacements for large binary or character objects.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.