70-764 Exam QuestionsBrowse all questions from this exam

70-764 Exam - Question 1


Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You need to configure a Microsoft SQL Server instance to ensure that a user named Mail1 can send mail by using Database Mail.

Solution: You add the DatabaseMailUserRole to Mail1 in the tempdb database.

Does the solution meet the goal?

Show Answer
Correct Answer: B

To configure a Microsoft SQL Server instance to allow a user to send mail using Database Mail, the user must be added to the DatabaseMailUserRole in the msdb database. Adding the user to this role in the tempdb database will not grant the necessary permissions, as the tempdb database is not where DatabaseMailUserRole is defined or used. Therefore, the solution provided does not meet the goal.

Discussion

3 comments
Sign in to comment
TheSwedishGuy
Jan 27, 2020

The DatabaseMailUserRole is not assigned in the tempDB database.

course104
Jan 24, 2021

Yes, only msdb

atz2021
Jan 5, 2021

The DatabaseMailUserRole can not be added in the tempDB.

Chandra111
Feb 21, 2021

The DBMail is completely related to MSDB.It should be require access on msdb.