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.
SQL user without login
B.
User mapped to an asymmetric key
C.
Domain user
D.
login mapped to a virtual account
Correct answer is C.
You are wrong. Correct answer is A because contained database user is mentioned. Users of the contained databases cannot have corresponding SQL server login.
I agree A is the right answer as the database is contained.
http://technet.microsoft.com/en-us/library/ff929071.aspx
so both seems OK.
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 master database. The database trusts the authentication by Windows.
After long research I a finally convinced by this post:
https://www.mssqltips.com/sqlservertip/2792/sql-server-contained-databases-for-database-refreshes/
Should be: A SQL User without login
I want to change my point of view… if you move it in the same domain, its much easier to take the domain user!
The answer is C obviously. The only type of users that isn’t linked to the actual SQL Server instance, but to something in the domain, is the account based on the domain user (so B and D are invalid, since they are bound to the instance).
Certificates don’t have to do anything with it, so that would make A invalid too.
I believe you have mentioned some very interesting details, thank you for the post.
Correct Answer is C
Although websites we backlink to below are considerably not connected to ours, we feel they may be basically really worth a go as a result of, so have a look.
usually posts some really interesting stuff like this. If you are new to this site
just beneath, are a lot of totally not associated internet sites to ours, on the other hand, they are certainly worth going over
The information and facts mentioned within the post are several of the very best accessible
one of our guests not long ago suggested the following website
we came across a cool web-site that you may delight in. Take a look when you want
Sites of interest we’ve a link to.
The info talked about inside the article are several of the ideal offered
please stop by the websites we comply with, such as this one particular, because it represents our picks in the web
Very handful of websites that take place to be comprehensive beneath, from our point of view are undoubtedly properly worth checking out.
Wonderful story, reckoned we could combine some unrelated data, nonetheless genuinely worth taking a search, whoa did one find out about Mid East has got more problerms too.
just beneath, are several entirely not associated web-sites to ours, however, they are certainly really worth going over
here are some links to websites that we link to due to the fact we consider they’re worth visiting
we prefer to honor lots of other online sites around the internet, even when they arent linked to us, by linking to them. Under are some webpages worth checking out
we prefer to honor many other net internet sites on the web, even though they arent linked to us, by linking to them. Beneath are some webpages really worth checking out
Great web sitewebsite! It looks really professional! Sustain the helpful job!
madden nfl 17 coins http://xunker.com/blog/member.asp?action=view&memName=AlfredoTompson72
I’d say the correct answer is A – “SQL user without login” since “[…]ensure that you can port the database to different database servers […] WITHOUT ADDITIONAL USER ACCOUNT CONFIGURATIONS”. Imho that means that it should not be necessary to migrate any LOGINS on the new target server in order to have a functional database.