What should you do?

You develop a Microsoft SQL Server 2012 database.

You create a view from the Orders and OrderDetails tables by using the following definition.

You need to improve the performance of the view by persisting data to disk.

What should you do?
A . Create an INSTEAD OF trigger on the view.
B . Create an AFTER trigger on the view.
C . Modify the view to use the WITH VIEW_METADATA clause.
D . Create a clustered index on the view.

View Answer

Answer: D

Explanation:

Reference: http://msdn.microsoft.com/en-us/library/ms188783.aspx