Developing SQL Databases — Question 5

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?

Answer options

• A. table-valued function
• B. a schema-bound view
• C. a partitioned view
• D. a DML trigger

Correct answer: B

Explanation

Creating a schema-bound view allows the view to be updated while ensuring that any changes are reflected in the underlying tables. Other options like a table-valued function and a DML trigger do not guarantee that changes in the view will directly update the base tables, and a partitioned view is primarily used for managing large datasets without affecting the update capability.