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?

A.
an indexed view

B.
a scalar function

C.
a table-valued function

D.
a table-valued type