DP-300 Question #453: Real Exam Question with Answer & Explanation

The correct answer is D: EXEC sp_read_error_log;. sp_readerrorlog (Transact-SQL) allows you to read the contents of the SQL Server or SQL Server Agent error log file and filter on keywords. https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp- readerrorlog-transact-sql?

Submitted by mateo_ar· Mar 6, 2026Perform administration by using T-SQL

Question

You have a Microsoft SQL Server 2022 instance. You need to troubleshoot failing SQL Agent Jobs. Which command should you run?

Options

AEXEC sp_trace_setfilter
BEXEC sp_help_jobserver
CEXEC sp_help_jobsteplog
DEXEC sp_read_error_log;

Explanation

sp_readerrorlog (Transact-SQL) allows you to read the contents of the SQL Server or SQL Server Agent error log file and filter on keywords. https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp- readerrorlog-transact-sql?

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice Browse All DP-300 Questions