Latest MCSE 70-462 Real Exam Download 61-66

Ensurepass

 

QUESTION 61

You administer a Microsoft SQL Server 2012 database named Contoso on a server named Server01.

 

You need to diagnose deadlocks that happen when executing a specific set of stored procedures by


recording events and playing them back on a different test server. What should you create?

A. an Extended Event session

B. a Policy

C. a Database Audit Specification

D. an Alert

E. a Server Audit Specification

F. a SQL Profiler Trace

G. a Resource Pool

 

Correct Answer: F

 

 

QUESTION 62

You administer a Microsoft SQL Server 2012 database named Contoso on a server named Server01.

 

You need to prevent users from disabling server audits in Server01. What should you create?

A. an Alert

B. a Resource Pool

C. an Extended Event session

D. a Database Audit Specification

E. a SQL Profiler Trace

F. a Server Audit Specification

G. a Policy

 

Correct Answer: G

 

 

QUESTION 63

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?

 

A. REVOKE SELECT ON Schema::Customers FROM UserA

B. DENY SELECT ON Object::Regions FROM UserA

C. EXEC sp_addrolemember ‘Sales’, ‘UserA’

D. DENY SELECT ON Object::Regions FROM Sales

E. REVOKE SELECT ON Object::Regions FROM UserA
F. DENY SELECT ON Schema::Customers FROM Sales
G. DENY SELECT ON Schema::Customers FROM UserA
H. EXEC sp_droprolemember ‘Sales’, ‘UserA’

I.  REVOKE SELECT ON Object::Regions FROM Sales

J. REVOKE SELECT ON Schema::Customers FROM Sales


Correct Answer: F

 

 

QUESTION 64

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 UserA is disallowed to select from any of the tables in the Customers schema. Which Transact-SQL statement should you use?

A. DENY SELECT ON Object::Regions FROM UserA

B. DENY SELECT ON Object::Regions FROM Sales

C. REVOKE SELECT ON Schema::Customers FROM Sales
D. REVOKE SELECT ON Schema::Customers FROM UserA
E. REVOKE SELECT ON Object::Regions FROM Sales

F. REVOKE SELECT ON Object::Regions FROM UserA
G. DENY SELECT ON Schema::Customers FROM Sales
H. DENY SELECT ON Schema::Customers FROM UserA

I.  EXEC sp_addrolemember ‘Sales’, ‘UserA’

J. EXEC sp droprolemember ‘Sales’, ‘UserA’

 

Correct Answer: H

 

 

QUESTION 65

You administer a SQL 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 remove the Select permission for UserA on the Regions table.

You also need to ensure that UserA can still access all the tables in the Customers schema, including the

Regions table, through the Sales role permissions.

 

Which Transact-SQL statement should you use?

 

A. DENY SELECT ON Object::Regions FROM UserA

B. DENY SELECT ON Schema::Customers FROM UserA

C. EXEC sp_addrolemember ‘Sales’, ‘UserA’

D. REVOKE SELECT ON Object::Regions FROM UserA
E. REVOKE SELECT ON Object::Regions FROM Sales
F. EXEC sp_droproiemember ‘Sales’, ‘UserA’

G. REVOKE SELECT ON Schema::Customers FROM UserA

H. DENY SELECT ON Object::Regions FROM Sales

I.  DENY SELECT ON Schema::Customers FROM Sales

J. REVOKE SELECT ON Schema::Customers FROM Sales

 

Correct Answer: D

 

 

QUESTION 66

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?

A. REVOKE SELECT ON Schema::Customers FROM UserA

B. REVOKE SELECT ON Object::Regions FROM UserA

C. EXEC sp_addrolemember ‘Sales’, ‘UserA’

D. DENY SELECT ON Schema::Customers FROM Sales

E. EXEC sp_droprolemember ‘Sales’, ‘UserA’

F. REVOKE SELECT ON Schema::Customers FROM Sales

G. DENY SELECT ON Object::Regions FROM UserA

H. REVOKE SELECT ON Object::Regions FROM Sales

I.  DENY SELECT ON Schema::Customers FROM UserA

J. DENY SELECT ON Object::Regions FROM Sales

 

Correct Answer: J

Download Latest 70-462 Real Free Tests , help you to pass exam 100%.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.