You need to improve the performance of the view by persisting data to disk. What should you do?
A. Modify the view to use the WITH VIEW_METADATA clause.
B. Create a clustered index on the view.
C. Create an INSTEAD OF trigger on the view.
D. Create an AFTER trigger on the view.
Answer:B
You need to improve the performance of the view by persisting data to disk. What should you do?
A. Modify the view to use the WITH VIEW_METADATA clause. B. Create a clustered index on the view. C. Create an INSTEAD OF trigger on the view. D. Create an AFTER trigger on the view.
Explanation: Reference: http://msdn.microsoft.com/en-us/library/ms188783.aspx