nerdexam
Microsoft

70-433 · Question #12

Your company's database contains Customers and Orders tables. You have been tasked to write a SELECT statement that outputs customer and order data as a valid and well-formed XML document. You are…

The correct answer is C. FOR XML PATH D. FOR XML EXPLICIT. See the full explanation below for the reasoning.

Question

Your company's database contains Customers and Orders tables. You have been tasked to write a SELECT statement that outputs customer and order data as a valid and well-formed XML document. You are required to mix attribute and element based XML within the document. You have determined that using the FOR XML AUTO clause will not be suitable. You need to identify the correct FOR XML clause to meet the requirement. Which FOR XML statement should you use? (Each correct answer represents a complete solution. Choose two.)

Options

  • AFOR BROWSE
  • BFOR XML RAW
  • CFOR XML PATH
  • DFOR XML EXPLICIT

How the community answered

(66 responses)
  • A
    5% (3)
  • B
    12% (8)
  • C
    83% (55)

Community Discussion

No community discussion yet for this question.

Full 70-433 Practice