Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft Exam 70-461 Topic 2 Question 1 Discussion

Actual exam question for Microsoft's 70-461 exam
Question #: 1
Topic #: 2
[All 70-461 Questions]

You use a Microsoft Azure SQL DataBase instance. The instance contains a table named Customers that has columns named Id, Name, and IsPriority.

You need to create a view named VwPriorityCustomers that:

* returns rows from Customer that have a value of True in the IsPriority column, and

* does not allow columns to be altered or dropped in the underlying table.

Which Transact-SQL statement shoul you run?

Show Suggested Answer Hide Answer
Suggested Answer: D

SCHEMABINDING 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.

References: https://docs.microsoft.com/en-us/sql/t-sql/statements/create-view-transact-sql?view=sql-server-2017


Comments

Currently there are no comments in this discussion, be the first to comment!


Save Cancel