Exam SnowPro Core topic 1 question 1159 discussion

D. TO_JSON Explanation: TO_JSON is used to convert relational data into JSON format, which is ideal when unloading a relational table into a JSON file. Why the others are wrong: A. PARSE_JSON: This function is used to parse a JSON string into a Snowflake-compatible format, not for converting relational data into JSON. B. JSON_EXTRACT_PATH_TEXT: This function extracts specific values from JSON data, but it doesn't convert relational data into JSON. C. OBJECT_CONSTRUCT: This creates a JSON object from key-value pairs, but it doesn't convert the entire relational data into JSON format. Example of using TO_JSON: SELECT TO_JSON(OBJECT_CONSTRUCT(*)) FROM my_table;