Microsoft Exam DP-300 Topic 3 Question 110 Discussion

Actual exam question for Microsoft's DP-300 exam

Question #: 110
Topic #: 3

[All DP-300 Questions]

You have an Azure SQL Database managed instance named SQLMI1. A Microsoft SQL Server Agent job runs

on SQLMI1.

You need to ensure that an automatic email notification is sent once the job completes.

What should you include in the solution?

AFrom SQL Server Configuration Manager (SSMS), enable SQL Server Agent

BFrom SQL Server Management Studio (SSMS), run sp_set_sqlagent_properties

CFrom SQL Server Management Studio (SSMS), create a Database Mail profile

DFrom the Azure portal, create an Azure Monitor action group that has an Email/SMS/Push/Voice action

Show Suggested Answer

Suggested Answer: C

by Devorah at Feb 12, 2025, 07:01 AM

Limited Time Offer

25%

Off

Get Premium DP-300 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Johnathon

23 hours ago

Option D looks interesting, but I'm not sure if it's the best solution since it's using Azure Monitor instead of the SQL Server Agent directly.

upvoted 0 times

...

Leatha

4 days ago

I think option C is the correct answer. Creating a Database Mail profile in SSMS will allow you to set up email notifications for the SQL Server Agent job.

upvoted 0 times

...

Roselle

6 days ago

I'm not sure, but maybe creating a Database Mail profile in SSMS could also work for sending email notifications.

upvoted 0 times

...

Frank

9 days ago

I agree with Barbra, setting up an Azure Monitor action group seems like the best way to ensure automatic email notifications.

upvoted 0 times

...

Barbra

16 days ago

I think we should go with option D, creating an Azure Monitor action group with Email/SMS/Push/Voice action.

upvoted 0 times

...