SnowPro Core Certification — Question 576

Which function can be combined with the copy command to unload a relational table into a JSON file?

Answer options

• A. FLATTEN
• B. LISTAGG
• C. OBJECT_CONSTRUCT
• D. PARSE_JSON

Correct answer: C

Explanation

The correct answer is C, OBJECT_CONSTRUCT, as it is specifically designed to create JSON objects, making it suitable for exporting data in JSON format. The other options, while useful in different contexts, do not directly facilitate the conversion of relational data into JSON when used with the copy command.