Exam 70-764 topic 1 question 101 discussion

Actual exam question from Microsoft's 70-764

Question #: 101
Topic #: 1

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?

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.

Show Suggested Answer

Suggested Answer: E 🗳️
Because the Include execution trace messages option can cause the error log to become large, only include execution trace messages in SQL Server Agent error logs when investigating a specific SQL Server Agent problem.
References: https://docs.microsoft.com/en-us/sql/ssms/agent/write-execution-trace-messages-to-sql-server-agent-log-ssms

by TheSwedishGuy at Jan. 28, 2020, 11:51 a.m.

Comments

Submit Cancel

TheSwedishGuy

5 years, 2 months ago

The AUTO_SHRINK option causes files to be shrunk when more than 25 percent of the file contains unused space. The file is shrunk to a size where 25 percent of the file is unused space, or to the size of the file when it was created, whichever is greater.

upvoted 1 times

...

TheSwedishGuy

5 years, 2 months ago

Yeah, we don't need to see SQL Agent execution trace flags every time.

upvoted 2 times

...

Exam 70-764 All Questions

View all questions & answers for the 70-764 exam

Exam 70-764 topic 1 question 101 discussion

Comments

TheSwedishGuy

TheSwedishGuy

SY0-701