nerdexam
Microsoft

70-432 · Question #47

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

(55 responses)
  • A
    9% (5)
  • B
    73% (40)
  • C
    15% (8)
  • D
    4% (2)

Community Discussion

No community discussion yet for this question.

Full 70-432 Practice