READ Free Dumps For Microsoft- 70-462
Question ID 18907 | You develop a Microsoft SQL Server 2012 database that contains tables named Employee You create a view named VwEmployee as shown in the following Transact-SQL statement.
Users are able to use single INSERT statements or INSERT...SELECT statements into this
|
Option A | CREATE TRIGGER TrgVwEmployee ON VwEmployee FOR INSERT AS BEGIN INSERT INTO Person(Id, FirstName, LastName) SELECT Id, FirstName, LastName, FROM inserted INSERT INTO Employee(PersonId, EmployeeNumber) SELECT Id, EmployeeNumber FROM inserted END |
Option B | CREATE TRIGGER TrgVwEmployee ON VwEmployee INSTEAD OF INSERT AS BEGIN INSERT INTO Person(Id, FirstName, LastName) SELECT Id, FirstName, LastName, FROM inserted INSERT INTO Employee(PersonId, EmployeeNumber) SELECT Id, EmployeeNumber FROM inserted END |
Option C | CREATE TRIGGER TrgVwEmployee ON VwEmployee INSTEAD OF INSERT AS BEGIN DECLARE @ID INT, @FirstName NVARCHAR(25), @LastName NVARCHAR(25), @PersonID INT, @EmployeeNumber NVARCHAR(15) SELECT @ID = ID, @FirstName = FirstName, @LastName = LastName, @EmployeeNumber = EmployeeNumber FROM inserted INSERT INTO Person(Id, FirstName, LastName) VALUES(@ID, @FirstName, @LastName) INSERT INTO Employee(PersonID, EmployeeNumber) VALUES(@PersonID, @EmployeeNumber End |
Option D | CREATE TRIGGER TrgVwEmployee ON VwEmployee INSTEAD OF INSERT AS BEGIN INSERT INTO Person(Id, FirstName, LastName) SELECT Id, FirstName, LastName FROM VwEmployee INSERT INTO Employee(PersonID, EmployeeNumber) SELECT Id, EmployeeNumber FROM VwEmployee End |
Correct Answer | B |
Question ID 18908 | You administer a SQL Server 2012 server that contains a database named SalesDB. |
Option A | REVOKE SELECT ON Schema::Customers FROM UserA |
Option B | REVOKE SELECT ON Object::Regions FROM UserA |
Option C | EXEC sp_addrolemember 'Sales', 'UserA' |
Option D | DENY SELECT ON Schema::Customers FROM Sales |
Option E | EXEC sp_droprolemember 'Sales', 'UserA' |
Option F | DENY SELECT ON Object::Regions FROM Sales |
Correct Answer | F |