Administering Microsoft SQL Server 2012/2014 Databases — Question 40

You use a contained database named ContosoDb within a domain.
You need to create a user who can log on to the ContosoDb database. You also need to ensure that you can port the database to different database servers within the domain without additional user account configurations.
Which type of user should you create?

Answer options

• A. SQL user without login
• B. User mapped to an asymmetric key
• C. Domain user
• D. login mapped to a virtual account

Correct answer: C

Explanation

Creating a Domain user allows for consistent authentication across different database servers within the domain, facilitating easy migration of the ContosoDb database. The other options either do not provide the required access or lack portability across servers, making them unsuitable for this scenario.