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

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.

View Answer

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.

References: https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-send-dbmail-transact-sql