nerdexam
Microsoft

70-433 · Question #162

Your company uses an application that passes XML to the database server by using stored procedures. The database server has a large number of XML handles that are currently active. You determine…

The correct answer is D. sp_xml__removedocument. See the full explanation below for the reasoning.

Question

Your company uses an application that passes XML to the database server by using stored procedures. The database server has a large number of XML handles that are currently active. You determine that the XML is not being flushed from SQL Server memory. You need to identify the system stored procedure to flush the XML from memory. Which Transact-SQL statement should you use?

Options

  • ADBCC DROPCLEANBUFFERS
  • BDBCC FREEPROCACHE
  • Csp_xml_preparedocument
  • Dsp_xml__removedocument

How the community answered

(47 responses)
  • A
    2% (1)
  • B
    4% (2)
  • C
    9% (4)
  • D
    85% (40)

Community Discussion

No community discussion yet for this question.

Full 70-433 Practice