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)- A2% (1)
- B4% (2)
- C9% (4)
- D85% (40)
Community Discussion
No community discussion yet for this question.