SnowPro Core Certification — Question 736

Which function determines the kind of value stored in a VARIANT column?

Answer options

• A. CHECK_JSON
• B. IS_ARRAY
• C. IS_JSON
• D. TYPEOF

Correct answer: D

Explanation

The TYPEOF function is specifically designed to return the data type of a value stored in a VARIANT column, making it the correct choice. The other options, while related to data types, do not provide the same functionality; CHECK_JSON is for validating JSON, IS_ARRAY checks for array types, and IS_JSON checks if the value is JSON formatted.