Administering a SQL Database Infrastructure — Question 31

You manage a Microsoft SQL Server environment. You plan to configure Database Mail.
You need to ensure that all users can access a private Database Mail profile.
What should you do?

Answer options

• A. On the tempdb database, add the DatabaseMailUserRole to userid 0.
• B. On the msdb database, add the DatabaseMailUserRole to the public user.
• C. On the master database, add the DatabaseMailUserRole to the public user.
• D. On the profile, grant access to the public user.

Correct answer: B

Explanation

The correct answer is B because adding the DatabaseMailUserRole to the public user in the msdb database allows all users to access the Database Mail profile. Options A and C are incorrect as they involve the wrong database (tempdb and master) and do not provide access to all users. Option D, while it mentions granting access, does not specify the necessary role in the correct database context.