READ Free Dumps For Microsoft- 70-462
| Question ID 18841 | 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. 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 any of
the tables in the Customers schema.
Which Transact-SQL statement should you use?
|
| Option A | REVOKE SELECT ON Schema::Customers FROM UserA
|
| Option B | DENY SELECT ON Object::Regions FROM UserA
|
| Option C | EXEC sp_addrolemember 'Sales', 'UserA'
|
| Option D | DENY SELECT ON Object::Regions FROM Sales
|
| Option E | REVOKE SELECT ON Object::Regions FROM UserA
|
| Option F | DENY SELECT ON Schema::Customers 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 http://msdn.microsoft.com/en-us/library/ms187728.aspx
| Question ID 18842 | You administer a Microsoft SQL Server 2012 database named Contoso on a server named
Server01.
You need to collect data for a long period of time to troubleshoot wait statistics when
querying Contoso. You also need to ensure minimum impact to the server.
What should you create?
|
| Option A | An Alert
|
| Option B | A Resource Pool
|
| Option C | An Extended Event session
|
| Option D | A Server Audit Specification
|
| Option E | A SQL Profiler Trace
|
| Option F | A Database Audit Specification
|
| Correct Answer | C |
Explanation