Microsoft
70-451 · Question #88
You have a table that has 10 million rows. The table has a view that returns all of the rows. You discover performance degradation when you run an unfiltered view. You need to recommend a solution…
The correct answer is C. a table-valued function. See the full explanation below for the reasoning.
Question
You have a table that has 10 million rows. The table has a view that returns all of the rows. You discover performance degradation when you run an unfiltered view. You need to recommend a solution to replace the view. The solution must require that the returned data is filtered by a parameter. What should you use?
Options
- Aan indexed view
- Ba scalar function
- Ca table-valued function
- Da table-valued type
How the community answered
(30 responses)- A3% (1)
- B13% (4)
- C80% (24)
- D3% (1)
Community Discussion
No community discussion yet for this question.