Microsoft
70-457 · Question #23
You have three tables that contain data for vendors, customers, and agents. You create a view that is used to look up telephone numbers for these companies. The view has the following definition…
The correct answer is D. Create an INSTEAD OF UPDATE trigger on the view. See the full explanation below for the reasoning.
Question
You have three tables that contain data for vendors, customers, and agents. You create a view that is used to look up telephone numbers for these companies. The view has the following definition:
You need to ensure that users can update only the phone numbers by using this view. What should you do?
Exhibit
Options
- AAlter the view.
- BDrop the view.
- CCreate an AFTER UPDATE trigger on the view.
- DCreate an INSTEAD OF UPDATE trigger on the view.
How the community answered
(20 responses)- A10% (2)
- B5% (1)
- C5% (1)
- D80% (16)
Community Discussion
No community discussion yet for this question.