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 18793

You administer a Microsoft SQL Server 2012 server. One of the databases on the server
supports a highly active OLTP application.
Users report abnormally long wait times when they submit data into the application.
You need to identify which queries are taking longer than 1 second to run over an extended
period of time.
What should you do?

Option A

use SQL Profiler to trace all queries that are processing on the server. Filter queries that have a Duration value of more than 1,000.

Option B

Use sp_configure to set a value for blocked process threshold. Create an extended event session.

Option C

 Use the Job Activity monitor to review all processes that are actively running. Review the Job History to find out the duration of each step.

Option D

Run the sp_who command from a query window.

Option E

Run the DBCC TRACEON 1222 command from a query window and review the SQL Server event log.

Correct Answer E
Explanation Explanation: Explanation/Reference: http://www.mssqltips.com/sqlservertip/2130/finding-sql-server-deadlocks-using-trace-flag- 1222/ http://msdn.microsoft.com/en-us/library/ms188396.aspx


Question ID 18794

You administer a Microsoft SQL Server 2012 database.
You provide temporary securityadmin access to User1 to the database server.
You need to know if User1 adds logins to securityadmin.
Which server-level audit action group should you use?

Option A

 SERVER_STATE_CHANGE_GROUP

Option B

SERVER_PRINCIPAL_IMPERSONATION_GROUP

Option C

SUCCESSFUL_LOGIN_GROUP

Option D

SERVER_ROLE_MEMBER_CHANGE_GROUP

Correct Answer D
Explanation Explanation: Explanation/Reference: http://technet.microsoft.com/en-us/library/cc280663.aspx SERVER_STATE_CHANGE_GROUP This event is raised when the SQL Server service state is modified. Equivalent to the Audit Server Starts and Stops Event Class. SERVER_PRINCIPAL_IMPERSONATION_GROUP This event is raised when there is an impersonation within server scope, such as EXECUTE AS . Equivalent to the Audit Server Principal Impersonation Event Class. SUCCESSFUL_LOGIN_GROUP Indicates that a principal has successfully logged in to SQL Server. Events in this class are raised by new connections or by connections that are reused from a connection pool. Equivalent to the Audit Login Event Class. SERVER_ROLE_MEMBER_CHANGE_GROUP This event is raised whenever a login is added or removed from a fixed server role. This event is raised for the sp_addsrvrolemember and sp_dropsrvrolemember stored procedures. Equivalent to the Audit Add Login to Server Role Event Class.