SnowPro Core Certification — Question 1181

What are the recommended alternative data types in Snowflake for unsupported large object data types such as BLOB and CLOB? (Choose two.)

Answer options

• A. VARIANT
• B. ARRAY
• C. BINARY
• D. OBJECT
• E. VARCHAR

Correct answer: C, E

Explanation

The correct answers are C and E because BINARY can store raw byte data similar to BLOB, and VARCHAR can accommodate large text strings akin to CLOB. Other options like VARIANT and OBJECT are not specifically designed for replacing BLOB or CLOB data types.