You use a contained database named ContosoDb withina 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 domainwithout
additional user account configurations.
Which type of user should you create?

A.
User mapped to a certificate

B.
SQL user without login

C.
Domain user

D.
SQL user with login

Explanation:
Contained user
There are two types of users for contained databases.
Contained database user with password
Contained database users with passwords are authenticated by the database.
Windows principals
Authorized Windows users and members of authorized Windows groups can connect directly to the database
and do not need logins in the masterdatabase. The database trusts the authentication by Windows.