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

Use the SQL Server Agent error log to find the job failure details.

Use the Activity Monitor to view the job's last 10 runs.

Enable 'log to table' in the job properties and review the table after each failure.

Query the msdb.dbo.sysjobhistory table for the job, filtering by run_date and run_time for the last 10 runs.

A SQL Server Agent job that runs a T-SQL script to archive old records fails with the error 'The transaction log for database 'mydb' is full'. The database uses the simple recovery model. You need to resolve the issue without changing the recovery model and with minimal impact on the application. What should you do?

Shrink the transaction log file and then rerun the job.

Modify the job to delete records in smaller batches and add a CHECKPOINT after each batch.

Change the job to use a different database with more log space.

Add more disk space to the log file and rerun the job.

A SQL Server Agent job has been running successfully for months, but last night it failed. The job history shows the step failed with error 22022, which indicates a SQL Server Agent error. You need to determine the root cause. What should you do first?

Check the SQL Server Agent error log for details around the time of the failure.

Review the job history for the step's 'Message' column to see the exact error text.

Check the Windows Application Event Log for SQL Server errors.

Run the job manually to see if it succeeds.

What is the primary purpose of SQL Server Agent in a SQL Server environment?

To automate administrative and recurring tasks such as backups, maintenance, and script execution

To optimize query performance by rewriting execution plans automatically

To provide a graphical interface for writing T-SQL queries

To manage the security permissions of database users and roles

Microsoft Certified:Azure Database Administrator Associate

Domain 4Objective 1

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

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 11–15

11application · medium
A SQL Server Agent job that runs a data import has been failing intermittently. You need to determine the exact error message and the step that failed for the last 10 runs. What should you do?
Select an answer first
12foundation · easy
Which T-SQL stored procedure is used to create a new SQL Server Agent job?
Select an answer first
13expert · hard
A SQL Server Agent job that runs a T-SQL script to archive old records fails with the error 'The transaction log for database 'mydb' is full'. The database uses the simple recovery model. You need to resolve the issue without changing the recovery model and with minimal impact on the application. What should you do?
Select an answer first
14expert · hard
A SQL Server Agent job has been running successfully for months, but last night it failed. The job history shows the step failed with error 22022, which indicates a SQL Server Agent error. You need to determine the root cause. What should you do first?
Select an answer first
15foundation · easy
What is the primary purpose of SQL Server Agent in a SQL Server environment?
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 3)

Questions 11–15

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

Which T-SQL stored procedure is used to create a new SQL Server Agent job?

A SQL Server Agent job has been running successfully for months, but last night it failed. The job history shows the step failed with error 22022, which indicates a SQL Server Agent error. You need to determine the root cause. What should you do first?

What is the primary purpose of SQL Server Agent in a SQL Server environment?

Keep studying — Configure and manage automation of tasks