A SQL Server Agent job that runs a weekly report has been failing for the past three weeks. You need to find out if the failure is consistent and what the error message is. What should you do?

Open the job history in SQL Server Management Studio and look at the last three runs.

Check the Windows Event Viewer for SQL Server Agent errors.

Query the msdb.dbo.sysjobs table to see the job's last run status.

Run the job manually and observe the output.

A SQL Server Agent job that runs a data import failed last night. You need to determine the exact error message and the step that failed. What should you do?

Check the Windows Event Log for SQL Server Agent errors.

View the job history in SQL Server Management Studio and expand the failed step to see the error message.

Run the job manually and observe the output in the job step properties.

Query the sysjobsteps table to find the last run status and error message.

A SQL Server Agent job that runs a data import has been failing, but the job history shows the step 'succeeded' and the job status is 'Succeeded'. However, the imported data is incorrect. You suspect the T-SQL script has a logic error. What should you do to identify the issue?

Enable 'log to table' in the job step to capture detailed output.

Add a step that logs the row counts before and after the import to a table, and review the log after the job runs.

Review the job history for any warnings or messages that might indicate a logic error.

Use the SQL Server Agent error log to see if there were any warnings.

Microsoft Certified:Azure Database Administrator Associate

Domain 4Objective 1

Create and Manage SQL Server Agent Jobs DP-300 Practice Questions (Page 1)

Part of the Configure and manage automation of tasks domain, which accounts for 15–20% of the DP-300 exam. Microsoft does not publish an official question count, but from its 100-minute exam (~40–65 total, ~6–13 in this domain), expect 2–4 from this objective — we provide 19 practice questions to prepare you well beyond it. (estimate)

19questions here

4free pages

9concepts

15–20%of the exam

Questions 1–5

1foundation · easy
Which SQL Server Agent object defines when a job should run, such as daily at 2:00 AM?
Select an answer first
2foundation · easy
Which system stored procedure is used to attach a schedule to an existing SQL Server Agent job?
Select an answer first
3application · medium
A SQL Server Agent job that runs a weekly report has been failing for the past three weeks. You need to find out if the failure is consistent and what the error message is. What should you do?
Select an answer first
4application · medium
A SQL Server Agent job that runs a data import failed last night. You need to determine the exact error message and the step that failed. What should you do?
Select an answer first
5expert · hard
A SQL Server Agent job that runs a data import has been failing, but the job history shows the step 'succeeded' and the job status is 'Succeeded'. However, the imported data is incorrect. You suspect the T-SQL script has a logic error. What should you do to identify the issue?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DP-300

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “DP-300” is a trademark of its owner, used for identification only.

Create and Manage SQL Server Agent Jobs DP-300 Practice Questions (Page 1)

Questions 1–5

Which SQL Server Agent object defines when a job should run, such as daily at 2:00 AM?

Which system stored procedure is used to attach a schedule to an existing SQL Server Agent job?

A SQL Server Agent job that runs a weekly report has been failing for the past three weeks. You need to find out if the failure is consistent and what the error message is. What should you do?

A SQL Server Agent job that runs a data import failed last night. You need to determine the exact error message and the step that failed. What should you do?

A SQL Server Agent job that runs a data import has been failing, but the job history shows the step 'succeeded' and the job status is 'Succeeded'. However, the imported data is incorrect. You suspect the T-SQL script has a logic error. What should you do to identify the issue?

Keep studying — Configure and manage automation of tasks