What should you do?

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?
A . Alter the view. Use the EXPAND VIEWS query hint along with each SELECT statement.
B . Create an INSTEAD OF UPDATE trigger on the view.
C . Drop the view. Re-create the view by using the SCHEMABINDING clause, and then create an index on the view.
D . Create an AFTER UPDATE trigger on the view.

Answer: B

Explanation:

Reference: http://msdn.microsoft.com/en-us/library/ms187956.aspx

Latest 70-461 Dumps Valid Version with 232 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments