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

Charolette

28 days ago

I'm leaning towards option C as well. Anything that involves the Azure portal tends to be more complex than necessary for a simple email notification.

upvoted 0 times

Maricela

21 days ago

User1: I think option C is the way to go for setting up the email notification.

upvoted 0 times

...

Ty

1 months ago

Haha, I bet the exam writers are having a field day with these Azure SQL Database questions. I'm going with option C, it sounds like the most straightforward approach.

upvoted 0 times

...

Johnathon

2 months 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

Trina

30 days ago

User2: I agree, creating a Database Mail profile in SSMS is a common way to send email notifications.

upvoted 0 times

...

Mitzie

1 months ago

User1: Option C might be a better choice for setting up email notifications.

upvoted 0 times

...

Leatha

2 months 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

...