From question; Finance department users must be able to retrieve data from the SalesHistory
table for sales persons where the value of the SalesYTD column is above a certain threshold.
CREATE VIEW (Transact-SQL) creates a virtual table whose contents (columns and rows) are
defined by a query. Use this statement to create a view of the data in one or more tables in the
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.
QUESTION: 2 DRAG DROP
Note: This question is part of a series of questions that use the same scenario. For your
convenience, the scenario is repeated in each question. Each question presents a different goal
and answer choices, but the text of the scenario is exactly the same in each question in this
You have a database named DB1 that contains the following tables: Customer,
CustomerToAccountBridge, and CustomerDetails. The three tables are part of the Sales
schema. The database also contains a schema named Website. You create the Customer table
by running the following Transact-SQL statement: