AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For Microsoft- 70-462





Question ID 18907

You develop a Microsoft SQL Server 2012 database that contains tables named Employee
and Person. The tables have the following definitions:

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
view. You need to ensure that users are able to use a single statement to insert records
into both Employee and Person tables by using the VwEmployee view.
Which Transact-SQL statement should you use?

 

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
Explanation


Question ID 18908

You administer a SQL Server 2012 server that contains a database named SalesDB.
SalesDb contains a schema named Customers that has a table named Regions. A user
named UserA is a member of a role named Sales.
UserA is granted the Select permission on the Regions table and the Sales role is granted
the Select permission on the Customers schema.
You need to ensure that the Sales role, including UserA, is disallowed to select from the
Regions table.
Which Transact-SQL statement should you use?

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
Explanation Explanation: Explanation/Reference: http://msdn.microsoft.com/en-us/library/ms188369.aspx http://msdn.microsoft.com/en-us/library/ms187750.aspx http://msdn.microsoft.com/en-us/library/ff848791.aspx

Send email to admin@getfreedumps for new dumps request!!!