Administering a SQL Database Infrastructure — Question 122

You administer a Microsoft SQL Server 2016 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?

Answer options

• A. Execute the sp_cycle_agent_errorlog stored procedure.
• B. Configure event forwarding.
• C. Enable the Auto Shrink option on the master database.
• D. Enable the Auto Shrink option on the msdb database.
• E. Disable the Include execution trace messages feature.

Correct answer: E

Explanation

The correct answer is E because disabling the Include execution trace messages feature will prevent detailed execution logs from being written, which contributes to the rapid growth of the SQL Agent Error Log. Options A, B, C, and D do not address the issue of excessive log growth effectively; for instance, executing sp_cycle_agent_errorlog will only cycle the log but not prevent future growth due to execution trace messages.