You have a view that includes an aggregate.
You must be able to change the values of columns in t
he 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
Explanation:
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 schemabound object exists as a schemabound object (ie you don-t remove schemabindi
ng) you are limited in changes that can be made to the tables or views that it refers to.
References: https://sqlstudies.com/2014/08/06/schemabinding-what-why/