You have three tables that contain data for dentists, psychiatrists, and physicians. You create a view
that is used to look up their email addresses and phone numbers.
The view has the following definition:
You need to ensure that users can update only the phone numbers and email addresses by using this
view.
What should you do?
A.
Alter the view. Use the EXPAND VIEWS query hint along with each SELECT statement.
B.
Create an INSTEAD OF UPDATE trigger on the view.
C.
Drop the view. Re-create the view by using the SCHEMABINDING clause, and then create an index
on the view.
D.
Create an AFTER UPDATE trigger on the view.
Explanation:
http://msdn.microsoft.com/en-us/library/ms187956.aspx
Create an instead of update trigger.