ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 70-464 All Questions

View all questions & answers for the 70-464 exam
Go to Exam

Exam 70-464 topic 1 question 122 discussion

Actual exam question from Microsoft's 70-464
Question #: 122
Topic #: 1
[All 70-464 Questions]

You have a SQL Server environment that contains two instances. The instances are configured as shown in the following table.

You fail over Database1 to Instance2.
After the failover is complete, a user receives the following error message when connecting to Database1 on Instance2:
"Msg 916, Level 14, State 1, Line 1
The server principal "Shared1" is not able to access the database "Database1" under the current security context."
You verify that there is a server login for Shared1 on Instance2
You need to ensure that Shared1 can connect to Database1 on Instance2.
What should you do?
More than one answer choice may achieve the goal. Select the BEST answer.

  • A. Create a new database user on Database1
  • B. Add Shared1 to the db_datareader role
  • C. Implement Windows authentication
  • D. Update the SID for Shared1 on Database1
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by [deleted] at April 4, 2025, 12:07 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Currently there are no comments in this discussion, be the first to comment!
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.

SaveCancel