Microsoft
70-451 · Question #132
You have a table that contains an XML column named XMLDatal. The column contains the following nodes: - Title - Description - Author - Weight - NumPages You need to design a stored procedure that…
The correct answer is D. Use XMLDatal.Query () in a select statement. See the full explanation below for the reasoning.
Question
You have a table that contains an XML column named XMLDatal. The column contains the following nodes:
- Title
- Description
- Author
- Weight
- NumPages
You need to design a stored procedure that will return only the title and description in a tabular result set. The solution must be developed by using minimum amount of effort. How should you extract the information?
Options
- AExecute sp_preparedocument.
- BUse FOR XML PATH in a select statement.
- CUse XMLDatal.Exists () in a select statement.
- DUse XMLDatal.Query () in a select statement.
How the community answered
(26 responses)- A4% (1)
- B4% (1)
- C8% (2)
- D85% (22)
Community Discussion
No community discussion yet for this question.