SnowPro Core Certification — Question 1195

Which functions can be used to identify the data type stored in a VARIANT column? (Choose two.)

Answer options

• A. IS_NULL_VALUE
• B. IS_DATE_VALUE
• C. IS_GEOGRAPHY
• D. IS_XML
• E. IS_JSON

Correct answer: A, B

Explanation

The functions IS_NULL_VALUE and IS_DATE_VALUE are specifically designed to identify whether the data in a VARIANT column is null or of date type, respectively. The other options, while they may relate to specific data types, do not serve the purpose of identifying data types for VARIANT columns.