DP-300 · Question #191
DP-300 Question #191: Real Exam Question with Answer & Explanation
The correct answer is C: Run the sp_configure command.. You would need to enable Database email extended procedure using Database Mail XPs configuration option: EXEC sp_configure 'show advanced options', 1; EXEC sp_configure 'Database Mail XPs', 1; Now you can test the configuration by sending emails using sp_send and sp_notify_operat
Question
You have an Azure SQL managed instance. You need to enable SQL Agent Job email notifications. What should you do?
Options
- AUse the Agent XPs option.
- BEnable the SQL Server Agent.
- CRun the sp_configure command.
- DRun the sp_set_agent_properties command.
Explanation
You would need to enable Database email extended procedure using Database Mail XPs configuration option: EXEC sp_configure 'show advanced options', 1; EXEC sp_configure 'Database Mail XPs', 1; Now you can test the configuration by sending emails using sp_send and sp_notify_operator https://techcommunity.microsoft.com/t5/azure-sql-blog/sending-emails-in-azure-sql-managed- instance/ba-p/386235
Community Discussion
No community discussion yet for this question.