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.
Explanation:
Reference:
http://msdn.microsoft.com/en-us/library/ms188783.aspx
Ans : A
0
1
I’m with D, can you explain why you reckon A saurabh?
1
0
It’s D obviously. Creating clustering index on a view makes data to be stored on the disk in precalculated state.
1
0
Same D here. “You need to improve the performance of the view by persisting data to disk”
0
0
d
0
0
Besides, part of new 200Q 70-461 dumps are available here:
https://drive.google.com/open?id=0B-ob6L_QjGLpfnJldlZxTklTaHM0akpJUzhja2pETHJOS0owMzd4eVk1UTVNQUpvdlVxVWM
Best Regards!
0
0