Contained Database Users Quiz

5 questions Pass: 70% +25 pts (50 with Pro)

Quiz covering Database Authentication

What you'll be asked

  1. What is the primary advantage of using a contained database user compared to a standard database user linked to a server-level login?
  2. Which database-level setting must be enabled at the server instance level before you can create contained database users?
  3. When creating a contained database user with a password, what is the correct syntax structure?
  4. If you move a database containing contained users to a different SQL Server instance, what must be verified on the destination server?
  5. A developer attempts to authenticate as a contained user but receives an error stating that the login failed. Which of the following is the most likely cause if the user exists and the password is correct?

Answers and explanations come after you submit.