Microsoft
70-457 · Question #62
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…
The correct answer is B. 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 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?
Exhibit
Options
- AAlter the view. Use the EXPAND VIEWS query hint along with each SELECT statement.
- BCreate an INSTEAD OF UPDATE trigger on the view.
- CDrop the view. Re-create the view by using the SCHEMABINDING clause, and then create an
- DCreate an AFTER UPDATE trigger on the view.
How the community answered
(34 responses)- A3% (1)
- B79% (27)
- C6% (2)
- D12% (4)
Community Discussion
No community discussion yet for this question.