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?
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.
Suggested Answer:B🗳️
For each private profile, Database Mail maintains a list of users that are permitted to send e-mail using that profile. Public profiles are available to users or roles in the msdb database who are also members of the DatabaseMailUserRole. By default, a profile is private, and no users are granted access to the profile. To make the profile public, grant access to the user 'public' or the user id 0. Note: Profiles are either public or private. A private profile is accessible only to specific users or roles. A public profile allows any user or role with access to the mail host database (msdb) to send e-mail using that profile. References: https://technet.microsoft.com/en-us/library/ms189879(v=sql.105).aspx
The solution states: By default, a profile is private, and no users are granted access to the profile. To make the profile public, grant access to the user 'public' or the user id 0.
So that would mean the correct answer is D
upvoted 7 times
...
This section is not available anymore. Please use the main Exam Page.70-764 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Guest
Highly Voted 5 years, 8 months ago