You need to configure each account’s profile security a…

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 account’s 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:

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 account’s 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:

Answer:

Explanation:
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.
https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-senddbmail-transact-sql



Leave a Reply 0

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