SnowPro Core Certification — Question 1027

What function, combined with the copy command, should be used to unload data from a relational table into a JSON file?

Answer options

• A. LATERAL
• B. CAST
• C. FLATTEN
• D. OBJECT_CONSTRUCT

Correct answer: D

Explanation

The correct answer is D. OBJECT_CONSTRUCT is specifically designed to create JSON objects, making it suitable for exporting data in that format. The other options, while useful in different contexts, do not serve the purpose of constructing JSON files from relational data.