Microsoft Exam 70-461 Topic 2 Question 1 Discussion

Actual exam question for Microsoft's 70-461 exam

Question #: 1
Topic #: 2

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?

ACREATE VIEW VwPriorityCustomers

BCREATE VIEW VwPriorityCustomers

CCREATE VIEW VwPriorityCustomers

DCREATE VIEW VwPriorityCustomers

Show Suggested 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

by Colette at May 09, 2022, 02:40 PM

Limited Time Offer

25%

Off

Get Premium 70-461 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

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