Valid 70-762 Dumps shared by ExamDiscuss.com for Helping Passing 70-762 Exam! ExamDiscuss.com now offer the newest 70-762 exam dumps, the ExamDiscuss.com 70-762 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 70-762 dumps with Test Engine here:
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?
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