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. a nonclustered index
B. a schema-bound view
C. a stored procedure
D. an INSTEAD OF trigger
Correct Answer: B
Explanation/Reference:
Explanation:
Binds the view to the schema of the underlying table or tables. When SCHEMABINDING is specified, the base table or tables cannot be modified in a way that would affect the view definition. Views or tables that participate in a view created with the SCHEMABINDING clause cannot be dropped unless that view is dropped or changed so that it no longer has schema binding.
References:
https://docs.microsoft.com/en-us/sql/t-sql/statements/create-view-transact-sql
D
https://docs.microsoft.com/en-us/sql/t-sql/statements/create-view-transact-sql?view=sql-server-ver15#updatable-views
“If the previous restrictions prevent you from modifying data directly through a view, consider the following options:
INSTEAD OF Triggers”