Developing SQL Databases — Question 142

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. a DML trigger
• B. a schema-bound view
• C. a stored procedure
• D. a DDL trigger

Correct answer: A

Explanation

Creating a DML trigger allows you to implement custom logic for data manipulation events, making the view updatable while ensuring that changes are reflected in the underlying tables. A schema-bound view does not inherently allow updates to the underlying data, while stored procedures and DDL triggers are not designed for this specific purpose.