What should you do?

You are a database developer on an instance of SQL Server 2008.
Weekly, your finance department receives XML from several branch offices. The data in these XML files must meet certain validation requirements. You currently have an XSD file that you want to use to validate the XML documents. What should you do?
A. Use OPENXML including a WITH clause.
B. Import the XML documents into an xml data type and use the exist() method.
C. Use FOR XML AUTO with the XMLSCHEMA option.
D. Register the XML schema using the CREATE XML SCHEMA COLLECTION statement.

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.