COF-C02 Question #651: Real Exam Question with Answer & Explanation

The correct answer is D: TO_JSON. The TO_JSON function in Snowflake is used to convert a relational table or individual rows into JSON format. This function is helpful for exporting data in JSON format. Using TO_JSON Function: SELECT TO_JSON(OBJECT_CONSTRUCT(*)) Exporting Data: The TO_JSON function converts the t

Data Loading and Unloading

Question

Which function is used to unload a relational table into a JSON file*?

Options

APARSE_JSON
BJSON_EXTRACT_PATH_TEXT
COBJECT_CONSTRUCT
DTO_JSON

Explanation

The TO_JSON function in Snowflake is used to convert a relational table or individual rows into JSON format. This function is helpful for exporting data in JSON format. Using TO_JSON Function: SELECT TO_JSON(OBJECT_CONSTRUCT(*)) Exporting Data: The TO_JSON function converts the table rows into JSON format, which can then be exported to a file.

Topics

#JSON functions#Data unloading#Data conversion#Relational to JSON

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice Browse All COF-C02 Questions