Provisioning SQL Databases — Question 25

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

The correct answer is C, a Domain user, because it allows the user to log in to the ContosoDb and remains consistent across different database servers within the domain. Options A and B do not provide the necessary login capabilities for the user, while option D is not relevant for contained databases which do not require a login mapped to a virtual account.