nerdexam
Microsoft

70-459 · Question #7

You run the following code: You need to ensure that the root node of the XML data stored in the Details column is <Order_Details>. What should you implement? More than one answer choice may achieve th

The correct answer is D. An XML schema collection. See the full explanation below for the reasoning.

Question

You run the following code: You need to ensure that the root node of the XML data stored in the Details column is <Order_Details>. What should you implement? More than one answer choice may achieve the goal. Select the BEST answer.

Exhibit

70-459 question #7 exhibit

Options

  • AA user-defined data type
  • BA Data Definition Language (DDL) trigger
  • CA data manipulation language (DML) trigger
  • DAn XML schema collection
  • EAn XML index

How the community answered

(41 responses)
  • A
    5% (2)
  • B
    2% (1)
  • C
    10% (4)
  • D
    83% (34)

Community Discussion

No community discussion yet for this question.

Full 70-459 Practice