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 domain without 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:
Reference: http://msdn.microsoft.com/en-us/library/ff929071.aspx
I’ve seen B as the answer in other places. What is the explanation for C?
0
0
The correct answer is B not C, they bring this question out every year b’cos 95% of the people keep getting it wrong.
0
0
B is incorrect, a user without login cannot log into the server.
Here is the doc
https://msdn.microsoft.com/en-us/library/ms173463.aspx
Users that authenticate at the database Only allowed in a contained database.
User based on a Windows user that has no login.
User based on a Windows group that has no login.
Contained database user with password.
Users that cannot authenticate These users cannot login to SQL Server or SQL Database.
User without a login. Cannot login but can be granted permissions.
User based on a certificate. Cannot login but can be granted permissions and can sign modules.
User based on an asymmetric key. Cannot login but can be granted permissions and can sign modules.
0
0
C is the correct answer,
because it satisfies this part of the question
“You also need to ensure that you can port the database to different database
servers within the domain without additional user account configurations”
without will cause OrphanIDs which isnt best practice.
0
0
By the way, part of the new 200Q 70-461 dumps are available here:
https://drive.google.com/open?id=0B-ob6L_QjGLpfnJldlZxTklTaHM0akpJUzhja2pETHJOS0owMzd4eVk1UTVNQUpvdlVxVWM
Best Regards!
0
0
looks like the dummps link provided
https://drive.google.com/open?id=0B-ob6L_QjGLpfnJldlZxTklTaHM0akpJUzhja2pETHJOS0owMzd4eVk1UTVNQUpvdlVxVWM
has some errors in answers
0
0