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?
A.
From SQL Server Configuration Manager (SSCM), enable SQL Server Agent
B.
From SQL Server Management Studio (SSMS), run sp_set_sqlagent_properties
C.
From SQL Server Management Studio (SSMS), create a Database Mail profile
D.
From the Azure portal, create an Azure Monitor action group that has an Email/SMS/Push/Voice action
Answer is correct. You have to create Database Mail Profile. Luke97 is referring to the profile name. -- Create a Database Mail profile
EXECUTE msdb.dbo.sysmail_add_profile_sp
@profile_name = 'AzureManagedInstance_dbmail_profile',
@description = '...' ;
Reference - https://techcommunity.microsoft.com/t5/azure-sql/sending-emails-in-azure-sql-managed-instance/ba-p/386235
If you want to send e-mail using SQL Agent jobs, there should be a profile that must be called 'AzureManagedInstance_dbmail_profile'. Otherwise, Managed Instance will be unable to send emails via SQL Agent.
Reference: https://techcommunity.microsoft.com/t5/azure-sql/sending-emails-in-azure-sql-managed-instance/ba-p/386235
"The important thing is that you can use any name for the DbMail profile (and you can have several db Mail profiles) for Db Mail procedures. However, if you want to send e-mail using SQL Agent jobs, there should be a profile that must be called 'AzureManagedInstance_dbmail_profile'. Otherwise, Managed Instance will be unable to send emails via SQL Agent. If you are using one profile in your instance and you want to use it both for classic emails and SQL Agent, rename the profile to 'AzureManagedInstance_dbmail_profile' so it can be used on both places."
you need to configure Database Mail (C) and create an Operator in SQL Agent in order to sent emails. No need for creating Azure action group (D) for this.
Should be D
Microsoft article below explains how to create an action group through the Azure portal.
https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/alerts-create?view=azuresql
C, creating a Database Mail profile, is also not applicable to Azure SQL Database Managed Instance. Database Mail is not supported in Azure SQL Database Managed Instance, so you cannot use it to send email notifications.
This section is not available anymore. Please use the main Exam Page.DP-300 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
ukp72
Highly Voted 3 years, 10 months agoLuke97
Highly Voted 3 years, 10 months agoJough_Blough
3 years, 10 months agovoodoo_sh
Most Recent 3 months agosca88
6 months, 1 week agokannan94
8 months agoigorclapa
1 year, 1 month agoSurjit24
1 year, 3 months agoyousiftech
1 year, 3 months agoLukasz1993
9 months, 2 weeks agoChunchi
2 years, 9 months ago