READ Free Dumps For Microsoft- 70-462
| Question ID 18883 | You administer a Microsoft SQL Server 2012 instance.
You discover that the SQL Agent Error Log file is rapidly growing in size.
You need to ensure that the SQL Agent Error Log file does not grow rapidly when SQL
Server agent jobs execute.
What should you do?
|
| Option A | Execute the sp_cycle_agent_errorlog stored procedure.
|
| Option B | Configure event forwarding.
|
| Option C | Enable the Auto Shrink option on the master database.
|
| Option D | Enable the Auto Shrink option on the msdb database.
|
| Option E | Disable the Include execution trace messages feature.
|
| Correct Answer | E |
Explanation
| Question ID 18884 | You administer a Microsoft SQL Server 2012.
A process that normally runs in less than 10 seconds has been running for more than an
hour.
You examine the application log and discover that the process is using session ID 60.
You need to find out whether the process is being blocked.
Which Transact-SQL statement should you use?
|
| Option A | EXEC sp_who 60
|
| Option B | SELECT * FROM sys.dm_exec_sessions WHERE sessionjd = 60
|
| Option C | EXEC sp_helpdb 60
|
| Option D | DBCC INPUTBUFFER (60)
|
| Correct Answer | A |
Explanation Explanation: Explanation/Reference: http://msdn.microsoft.com/en-us/library/ms174313.aspx http://msdn.microsoft.com/en-us/library/ms176013.aspx http://msdn.microsoft.com/en-us/library/ms178568.aspx http://msdn.microsoft.com/en-us/library/ms187730.aspx