Answer: JSON, SQL

The question asks about the two types of NULL values supported in semi-structured data in Snowflake. According to Snowflake documentation and the community discussion (with 100% consensus for BE), Snowflake supports: 1) SQL NULL - which means the value is missing or unknown, consistent with structured data types, and 2) JSON null (also called VARIANT NULL) - which is stored as a string containing 'null' in VARIANT columns to distinguish it from SQL NULL. Option B (JSON) represents JSON null, and option E (SQL) represents SQL NULL. Options A (Avro), C (ORC), and D (Parquet) are file formats, not types of NULL values, making them incorrect.

Author: LeetQuiz Editorial Team