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.
Disagree. You should create a Domain user in this case.
I agree that the correct answer is C!
domain user is correct. domain is the keyword.
plus i saw the answer here: http://www.accelerated-ideas.com/free-70462-practice-test.aspx#.VZ_e9_lVj-U
You would need to create a SQL login on each server that you port the database to and the question states without additional user account configuration.
Domain user is the correct answer.