Exam Code: 70-459
Exam Name: Microsoft Transition MCITP: DB Admin 08 or MCITP: DB Dev 08 to
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. Materialize the view.
B. Create an INSTEAD OF trigger on the view.
C. Define the view by using the CHECK option.
D. Define the view by using the SCHEMABINDING option.
Correct Answer: B