Home » Microsoft » 70-762 » What should you create?
You have a view that includes an aggregate.
You must be able to change the values of columns in the view. The changes must be reflected in the tables that the view uses. You need to ensure that you can update the view.
What should you create?
A. table-valued function
B. a schema-bound view
C. a partitioned view
D. a DML trigger
Correct Answer: B
Explanation/Reference:
When you use the SchemaBinding keyword while creating a view or function you bind the structure of any underlying tables or views. It means that as long as that schem abound object exists as a schem abound object (ie you don’t remove schemabinding) you are limited in changes that can be made to the tables or views that it refers to.
https://sqlstudies.com/2014/08/06/schemabinding-what-why/
You should use an instead of insert trigger.