What should you do?

You are creating an application that will connect to the AgentPortal database by using a SQL login named AgentPortalUser. Stored procedures in the database will use sp_send_dbmail to send email messages.
You create a user account in the msdb database for the AgentPortalUser login. You use the Database Mail Configuration Wizard to create a Database Mail profile.
Security has not been configured for the Database Mail profile.
You need to ensure that AgentPortalUser can send email messages.
What should you do?
A. Configure the AgentPortalUser user as a member of SQLAgentOperatorRole in the msdb database.
B. Configure the Microsoft SQL Server Agent to use Database Mail.
C. Enable the guest user in the msdb database.
D. Configure the AgentPortalUser user as a member of DatabaseMailUserRole in the msdb database.

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.