You have a SQL Server Agent job that runs an index maintenance routine. The job currently runs every Sunday at 1:00 AM. Management now requires the job to also run on the first day of each month at 2:00 AM. You need to modify the job schedule without creating a new job. What should you do?

Create a new job with a monthly schedule and have it call the original job using sp_start_job.

Change the existing schedule to run monthly on day 1 at 2:00 AM.

Add a second schedule to the job that runs monthly on day 1 at 2:00 AM.

Modify the job step to include a condition that checks the date and exits if it is not the first of the month.

You need to monitor a SQL Server Agent job that runs every hour. You want to receive an email if the job does not run at its scheduled time. What should you configure?

Create an alert on the job that fires when the job does not start at its scheduled time.

Create a separate monitoring job that checks the job history for missed runs and sends an email if a run is missing.

Configure the job to write to the Windows Event Log if it does not start, and have a monitoring tool send an email.

Configure the job to send an email if it does not start within 5 minutes of the scheduled time.

Which SQL Server component is responsible for executing jobs on a scheduled basis?

SQL Server Analysis Services (SSAS)

SQL Server Integration Services (SSIS)

SQL Server Reporting Services (SSRS)

A SQL Server Agent job that performs a database consistency check (DBCC CHECKDB) is scheduled to run every Sunday. You want to be notified if the job fails, but you also want to be notified if the job does not run at all on a Sunday. What should you configure?

Configure the job to send an email on success and on failure.

Create a separate job that runs on Monday morning and checks the job history for the previous Sunday's run; if no run is found, send an email.

Enable the job's 'notify on idle' option to send an email when the job is not running.

Create an alert on the job that fires on 'failure' and set a notification to email the DBA team.

Microsoft Certified:Azure Database Administrator Associate

Domain 4Objective 1

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

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 6–10

6application · medium
You have a SQL Server Agent job that runs an index maintenance routine. The job currently runs every Sunday at 1:00 AM. Management now requires the job to also run on the first day of each month at 2:00 AM. You need to modify the job schedule without creating a new job. What should you do?
Select an answer first
7application · hard
You need to monitor a SQL Server Agent job that runs every hour. You want to receive an email if the job does not run at its scheduled time. What should you configure?
Select an answer first
8foundation · easy
Which SQL Server component is responsible for executing jobs on a scheduled basis?
Select an answer first
9foundation · easy
In SQL Server Management Studio (SSMS), which object is created under the 'SQL Server Agent' node to automate a series of tasks?
Select an answer first
10application · medium
A SQL Server Agent job that performs a database consistency check (DBCC CHECKDB) is scheduled to run every Sunday. You want to be notified if the job fails, but you also want to be notified if the job does not run at all on a Sunday. What should you configure?
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.