Microsoft
70-459 · Question #1
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?
The correct answer is B. Create an INSTEAD OF trigger on the view. See the full explanation below for the reasoning.
Question
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?
Options
- AMaterialize the view.
- BCreate an INSTEAD OF trigger on the view.
- CDefine the view by using the CHECK option.
- DDefine the view by using the SCHEMABINDING option.
How the community answered
(56 responses)- A2% (1)
- B84% (47)
- C4% (2)
- D11% (6)
Community Discussion
No community discussion yet for this question.