A SQL Server Agent job that runs a data refresh is scheduled to run every hour from 8:00 AM to 6:00 PM on weekdays. You need to add an additional run at 7:00 AM on weekdays. What is the most efficient way to modify the schedule?

Create a second schedule that runs at 7:00 AM on weekdays and attach it to the job.

Modify the existing schedule to start at 7:00 AM and run every hour until 6:00 PM.

Create a new job with a schedule that runs at 7:00 AM and have it call the original job.

Disable the existing schedule and create a new schedule that runs at 7:00 AM and every hour from 8:00 AM to 6:00 PM.

What is a job step in SQL Server Agent?

A single task or command that is executed as part of a job

A database object that stores job execution history

A notification sent when a job completes

A schedule that defines when a job runs

You have a SQL Server Agent job that runs a report generation process. The job must run on weekdays at 8:00 AM and also on the last day of each month at 6:00 PM. You need to configure the schedule. What should you do?

Create two separate schedules for the job: one for weekdays at 8:00 AM and one for the last day of the month at 6:00 PM.

Create a single schedule that runs daily at 8:00 AM and also at 6:00 PM, and then use a condition to skip non-weekdays.

Create a single schedule that runs on weekdays at 8:00 AM and set the 'Last day of the month' option for the same schedule.

Create a single schedule that runs on the last day of the month at 6:00 PM and use a T-SQL step to check if it is a weekday.

A database administrator wants to configure a SQL Server Agent job to send an email notification to the operations team whenever the job fails. Which SQL Server Agent component must be configured first so that email notifications can be sent?

Enable the SQL Server Agent service to run under a domain account that has permission to send email.

Configure Database Mail and set the SQL Server Agent mail profile to that Database Mail profile.

Create an operator and assign it to the job's notification settings.

Add a job step that uses the sp_send_dbmail stored procedure to send the email.

Microsoft Certified:Azure Database Administrator Associate

Domain 4Objective 1

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

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 16–19

16application · medium
A SQL Server Agent job that runs a data refresh is scheduled to run every hour from 8:00 AM to 6:00 PM on weekdays. You need to add an additional run at 7:00 AM on weekdays. What is the most efficient way to modify the schedule?
Select an answer first
17foundation · easy
What is a job step in SQL Server Agent?
Select an answer first
18application · medium
You have a SQL Server Agent job that runs a report generation process. The job must run on weekdays at 8:00 AM and also on the last day of each month at 6:00 PM. You need to configure the schedule. What should you do?
Select an answer first
19foundation · medium
A database administrator wants to configure a SQL Server Agent job to send an email notification to the operations team whenever the job fails. Which SQL Server Agent component must be configured first so that email notifications can be sent?
Select an answer first

Finished these 4 questions?

Review the revealed explanations, or continue through the curriculum.

No more pagesBack 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.