nerdexam
Microsoft

70-433 · Question #50

You are a database developer for your company. You are developing a stored procedure that must accept a parameter of the xml data type and store the data in a relational table structure. You need to…

The correct answer is B. the nodes method of the xml data type. See the full explanation below for the reasoning.

Question

You are a database developer for your company. You are developing a stored procedure that must accept a parameter of the xml data type and store the data in a relational table structure. You need to write the stored procedure to fulfill the requirements. Which functionality should you use?

Options

  • AFOR XML AUTO
  • Bthe nodes method of the xml data type
  • Cthe query method of the xml data type
  • Dthe modify method of the xml data type

How the community answered

(28 responses)
  • A
    4% (1)
  • B
    86% (24)
  • C
    4% (1)
  • D
    7% (2)

Community Discussion

No community discussion yet for this question.

Full 70-433 Practice