Microsoft
70-465 · Question #58
You need to recommend a solution that addresses the installation issues. What should you include in the recommendation?
The correct answer is C. Contained users. Scenario: Installation Issues The current version of the ERP application requires that several SQL Server logins be set up to function correctly. Most customers set up the ERP application in multiple locations and must create logins multiple times. - Creating contained users…
Submitted by anjalisingh· Mar 5, 2026Design database security solutions
Question
You need to recommend a solution that addresses the installation issues. What should you include in the recommendation?
Options
- AWindows logins
- BServer roles
- CContained users
- DDatabase roles
How the community answered
(48 responses)- A8% (4)
- B2% (1)
- C75% (36)
- D15% (7)
Explanation
- Scenario: Installation Issues The current version of the ERP application requires that several SQL Server logins be set up to function correctly. Most customers set up the ERP application in multiple locations and must create logins multiple times. - Creating contained users enables the user to connect directly to the contained database. This is a very significant feature in high availability and disaster recovery scenarios such as in an AlwaysOn solution. If the users are contained users, in case of failover, people would be able to connect to the secondary without creating logins on the instance hosting the secondary. This provides an immediate benefit.
Topics
#Contained users#Database portability#User management#Authentication
Community Discussion
No community discussion yet for this question.