19. You are defining new SQL Service Broker objects. Your messages must contain
XML data, but there are several different schemas that can be used that will be
identified by the receiving process by querying the XML document within the
message body to identify which code branch to use. What validation method
should you use when creating the Message Type?
A. NONE
B. EMTPY
C. WELL_FORMED_XML
D. VALID_XML WITH SCHEMA COLLECTION
Answer C is correct. You should select the WELL_FORMED_XML. The
VALID_XML WITH SCHAMA COLLECTION option requires a single XML
schema be defined. Because your requirement is that different XML schemas
can be sent, but you want to ensure that the XML is valid, the WELL_
FORMED_XML option is the correct answer.
Bạn đang xem 19. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P162 PPTX
