Contained Database Users Quiz

Quiz covering Database Authentication

Questions in this quiz

A preview of the 5 questions covered. Start the quiz above to answer them, check your score, and read the explanations.

1. 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. 2

   Which database-level setting must be enabled at the server instance level before you can create contained database users?

3. 3

   When creating a contained database user with a password, what is the correct syntax structure?

4. 4

   If you move a database containing contained users to a different SQL Server instance, what must be verified on the destination server?

5. 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?