Administering a SQL Database Infrastructure — Question 163

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. User mapped to a certificate
• B. SQL user without login
• C. Domain user
• D. SQL user with login

Correct answer: C

Explanation

The correct answer is C, as a Domain user can log in to the ContosoDb database and will retain access when the database is moved to different servers within the domain. The other options either do not support logging in directly or are not suitable for maintaining the necessary user configurations across server migrations.