Exam DP-300 topic 4 question 29 discussion

Actual exam question from Microsoft's DP-300

Question #: 29
Topic #: 4

You have an Azure SQL managed instance.

You need to configure the SQL Server Agent service to email job notifications.

Which statement should you execute?

A. EXECUTE msdb.dbo.sysmail_add_profile_sp @profile_name = ‘sysadmin_dbmail_profile’;
B. EXECUTE msdb.dbo.sysmail_add_profile_sp @profile_name = ‘application_dbmail_profile’;
C. EXECUTE msdb.dbo.sysmail_add_profile_sp @profile_name = ‘AzureManagedInstance_dbmail_profile’;
D. EXECUTE msdb.dbo.sysmail_add_profile_sp @profile_name = ‘sys_dbmail_profile’;

Show Suggested Answer

Suggested Answer: C 🗳️

by dryd at April 15, 2023, 8:08 a.m.

Comments

Submit Cancel

examdemo

8 months, 3 weeks ago

Selected Answer: C

Correct

upvoted 1 times

...

OBIJUAN88

1 year, 7 months ago

Selected Answer: C

-- Add the account to the profile EXECUTE msdb.dbo.sysmail_add_profileaccount_sp @profile_name = 'AzureManagedInstance_dbmail_profile', @account_name = 'SQL Agent Account', @sequence_number = 1;

upvoted 3 times

...

Pranava_GCP

1 year, 7 months ago

Selected Answer: C

C is correct. https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/job-automation-managed-instance?view=azuresql#job-notifications

upvoted 4 times

...

Correct. To send e-mail using SQL Agent jobs in SQL Managed Instance, there should be a profile that must be called AzureManagedInstance_dbmail_profile. Otherwise, SQL Managed Instance will be unable to send emails via SQL Agent. https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/job-automation-managed-instance?view=azuresql#sql-agent-job-notifications

upvoted 3 times

...