Microsoft
70-459 · Question #54
You need to recommend a solution to improve the performance of usp_UpdateInventory. The solution must minimize the amount of development effort. What should you include in the recommendation?
The correct answer is C. a common table expression. See the full explanation below for the reasoning.
Question
You need to recommend a solution to improve the performance of usp_UpdateInventory. The solution must minimize the amount of development effort. What should you include in the recommendation?
Options
- Aa table variable
- Ba subquery
- Ca common table expression
- Da cursor
How the community answered
(25 responses)- A8% (2)
- B4% (1)
- C84% (21)
- D4% (1)
Community Discussion
No community discussion yet for this question.