U.S. Independence Day Deal! Unlock 25% OFF Today – Limited-Time Offer - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft DP-300 Exam - Topic 3 Question 110 Discussion

You have an Azure SQL Database managed instance named SQLMI1. A Microsoft SQL Server Agent job runson SQLMI1.You need to ensure that an automatic email notification is sent once the job completes.What should you include in the solution?
C) From SQL Server Management Studio (SSMS), create a Database Mail profile
A) From SQL Server Configuration Manager (SSMS), enable SQL Server Agent
B) From SQL Server Management Studio (SSMS), run sp_set_sqlagent_properties
D) From the Azure portal, create an Azure Monitor action group that has an Email/SMS/Push/Voice action

Microsoft DP-300 Exam - 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?

Show Suggested Answer Hide 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:

0/2000 characters
Submit Cancel
Daren
7 months ago
Option D seems like overkill for just email notifications.
upvoted 0 times
...
Launa
7 months ago
I disagree, enabling SQL Server Agent alone won't send emails.
upvoted 0 times
...
Malcolm
7 months ago
Wait, can you really do that from Azure Monitor too? Sounds interesting!
upvoted 0 times
...
Percy
8 months ago
Definitely option C! That's the way to go.
upvoted 0 times
...
Rozella
8 months ago
You need to set up Database Mail for email notifications.
upvoted 0 times
...
Jodi
8 months ago
I recall that sp_set_sqlagent_properties was mentioned in our study materials, but I can't remember if it directly relates to email notifications. Option B could be a possibility.
upvoted 0 times
...
Lorean
8 months ago
I think we practiced something similar where we had to configure alerts. Option D sounds familiar, but I’m not confident about using the Azure portal for this.
upvoted 0 times
...
Vashti
8 months ago
I'm not entirely sure, but I feel like enabling SQL Server Agent is important too. Maybe option A is relevant?
upvoted 0 times
...
Nieves
8 months ago
I remember we talked about setting up Database Mail for notifications, so I think option C might be the right choice.
upvoted 0 times
...
Dana
8 months ago
I'm leaning towards the Azure Monitor action group option. That seems like the most modern and cloud-based approach to setting up email notifications. I'll make sure to review the details on how to configure that in the Azure portal.
upvoted 0 times
...
Shenika
8 months ago
Okay, let's see. I think the key here is to set up a Database Mail profile in SQL Server Management Studio. That should allow the SQL Server Agent job to send email notifications when it completes. I'll make sure to double-check the steps.
upvoted 0 times
...
Brent
8 months ago
Hmm, I'm a bit unsure about this one. I know we need to set up some kind of email notification, but I'm not sure if it's a SQL Server configuration or an Azure Portal task. I'll have to review the options closely.
upvoted 0 times
...
Hollis
9 months ago
This looks like a straightforward SQL Server Agent job configuration question. I'll need to think through the options carefully, but I'm confident I can solve this.
upvoted 0 times
...
Charolette
1 year 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
Darnell
1 year ago
User3: Yeah, I prefer keeping it simple with option C as well.
upvoted 0 times
...
Jesse
1 year ago
User2: I agree, using Database Mail profile in SSMS seems like the simplest solution.
upvoted 0 times
...
Maricela
1 year ago
User1: I think option C is the way to go for setting up the email notification.
upvoted 0 times
...
...
Ty
1 year 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
Hubert
1 year ago
User3: I agree, setting up email notifications through a Database Mail profile is a common practice.
upvoted 0 times
...
Chantay
1 year ago
User2: Yeah, creating a Database Mail profile in SSMS seems like the most direct solution.
upvoted 0 times
...
Laura
1 year ago
User1: I think option C is the way to go.
upvoted 0 times
...
...
Johnathon
1 year 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
1 year ago
User2: I agree, creating a Database Mail profile in SSMS is a common way to send email notifications.
upvoted 0 times
...
Mitzie
1 year ago
User1: Option C might be a better choice for setting up email notifications.
upvoted 0 times
...
...
Leatha
1 year 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
1 year 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
1 year 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
1 year ago
I think we should go with option D, creating an Azure Monitor action group with Email/SMS/Push/Voice action.
upvoted 0 times
...

Save Cancel