Exam 70-764 topic 1 question 51 discussion

HOTSPOT -
You are the database administrator of a Microsoft SQL Server instance. Developers are writing stored procedures to send emails using sp_send_dbmail.
Database Mail is enabled.
You need to configure each accounts profile security and meet the following requirements:
✑ Account SMTP1_Account must only be usable by logins that have been given explicit permissions to use the SMTP1_profile.
✑ Account SMTP2_Account must only be usable by logins who are a member of the [DatabaseMailUserRole] role in msdb.
In the table below. identify the profile type that must be used for each account.
NOTE: Make only one selection in each column.
Hot Area:

Suggested Answer:
SMTP1_Account1: Private Profile -
When no profile_name is specified, sp_send_dbmail uses the default private profile for the current user. If the user does not have a default private profile, sp_send_dbmail uses the default public profile for the msdb database.

SMTP1_Account2: Default Profile -
Execute permissions forsp_send_dbmail default to all members of the DatabaseMailUser database role in the msdb database.
References: https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-send-dbmail-transact-sql