What should you include in the recommendation?

You need to recommend a solution that addresses the installation issues.

What should you include in the recommendation?
A . Windows logins
B . Server roles
C . Contained users
D . Database roles

View Answer

Answer: C

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.