CORRECT TEXT
You need to create a view named uv_CustomerFullNames. The view must prevent the underlying
structure of the customer table from being changed.
Part of the correct T-SQL statement has been provided in the answer area. Provide the complete
code.
Answer: See the explanation
Explanation:
CREATE VIEW sales.uv_CustomerFullNames
WITH SCHEMABINDING
AS SELECT
FirstName,
LastName
FROM Sales.Customers
CREATE VIEW sales.uv_CustomerFullNames
WITH SCHEMABINDING
AS SELECT
Sales.FirstName,
Sales.LastName
FROM Sales.Customers
When you use SCHEMABINDING, the select_statement must include the two-part names (schema.object) of tables, views, or user-defined functions that are referenced.
https://msdn.microsoft.com/en-us/library/ms173846.aspx
0
0
That is CORRECT Giovanni!
You go on to the next round and might be winning a washing machine!
Seriously: well noticed!
0
0
When you use SCHEMABINDING you don’t have to use two-part names for columns, only for tables, views or user-defined functions names.
0
0
What’s more, part of that new 200Q 70-461 dumps are available here:
https://drive.google.com/open?id=0B-ob6L_QjGLpfnJldlZxTklTaHM0akpJUzhja2pETHJOS0owMzd4eVk1UTVNQUpvdlVxVWM
Best Regards!
0
0