Microsoft
70-451 · Question #35
You have a table that has an XML column named XMLOrderHeader. You need to design a stored procedure that extracts the order header values and stores them in a table. The solution must meet the…
The correct answer is D. For each value, use an XPATH statement. See the full explanation below for the reasoning.
Question
You have a table that has an XML column named XMLOrderHeader. You need to design a stored procedure that extracts the order header values and stores them in a table. The solution must meet the following requirements:
- Extract many values
- Minimize the development effort
What should the solution include?
Options
- AUse a single Exists() method.
- BUse a single XPATH statement.
- CFor each value, use the Exists() method.
- DFor each value, use an XPATH statement.
How the community answered
(28 responses)- A4% (1)
- B18% (5)
- C7% (2)
- D71% (20)
Community Discussion
No community discussion yet for this question.