Answer: OBJECT_CONSTRUCT()

The question asks which Snowflake function is used to export relational data into JSON format. OBJECT_CONSTRUCT() is specifically designed to create JSON objects from relational data by taking key-value pairs as arguments and returning a JSON object. This makes it the optimal choice for converting relational data to JSON format. The community discussion shows 100% consensus on answer B (OBJECT_CONSTRUCT()), with multiple users confirming this is correct and providing supporting documentation links. The other options are less suitable: BUILD_STAGE_FILE_URL() is for generating URLs to stage files, PARSE_JSON() is for parsing existing JSON strings into JSON objects, and TO_VARIANT() is for converting data to VARIANT type, not specifically for JSON export.

Author: LeetQuiz Editorial Team