SnowPro Core Certification — Question 960

Which command should be used to look into the validity of an XML object in Snowflake?

Answer options

• A. XMLGET
• B. TO_XML
• C. PARSE_XML
• D. CHECK_XML

Correct answer: D

Explanation

The correct answer is D, CHECK_XML, which is specifically designed to validate the structure of an XML object. The other options, while related to XML handling, do not serve the purpose of validation; XMLGET retrieves XML data, TO_XML converts data to XML format, and PARSE_XML parses XML strings but does not validate them.