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.