nerdexam
Microsoft

70-451 · Question #34

You plan to implement a Web-based application that will save XML data to a column in a table. You need to design a query that ensures that before saving the XML data to the table, the data contains…

The correct answer is A. .exist(). See the full explanation below for the reasoning.

Question

You plan to implement a Web-based application that will save XML data to a column in a table. You need to design a query that ensures that before saving the XML data to the table, the data contains valid elements. The solution must be developed by using the minimum amount of effort. What should you include in the query?

Options

  • A.exist()
  • B.query()
  • CFOR XML PATH
  • Dsp_xml_preparedocument

How the community answered

(49 responses)
  • A
    78% (38)
  • B
    6% (3)
  • C
    2% (1)
  • D
    14% (7)

Community Discussion

No community discussion yet for this question.

Full 70-451 Practice