Answer: IS_NULL_VALUE, IS_DATE_VALUE

The question asks for functions that can identify the data type stored in a VARIANT column. According to Snowflake documentation and the community discussion (with upvoted comments confirming), IS_NULL_VALUE and IS_DATE_VALUE are valid functions for this purpose. IS_NULL_VALUE checks if a VARIANT value is NULL, and IS_DATE_VALUE checks if it can be interpreted as a date. The other options—IS_GEOGRAPHY, IS_XML, and IS_JSON—are not actual Snowflake functions; while Snowflake supports GEOGRAPHY, XML, and JSON data types, these specific functions do not exist. Thus, A and B are the correct choices.

Author: LeetQuiz Editorial Team