Home » Microsoft » 70-466 v.2 » What should you do?
You have an application that uses a view to access data from multiple tables.
You need to ensure that you can insert rows into the underlying tables by using the view.
What should you do?
A. Define the view by using the SCHEMABINDING option.
B. Define the view by using the CHECK option.
C. Create an INSTEAD OF trigger on the view.
D. Materialize the view.
Correct Answer: C
Explanation/Reference:
Explanation:
Using INSTEAD OF triggers you can override an INSERT, UPDATE, or DELETE operation on a view. For example, you might define an INSTEAD OF INSERT trigger on a view to replace the standard INSERT statement.
References: https://msdn.microsoft.com/en-us/library/def01zh2.aspx