Administering a SQL Database Infrastructure — Question 235

You need to move a database in between servers.
You need to guarantee database users will be able to login in the database with a minimum of management effort.

Answer options

• A. Application role
• B. Database user
• C. Server login
• D. Server role

Correct answer: B

Explanation

The correct answer is B, Database user, as it allows users to access the database directly after migration without additional configuration. Options A and D pertain to roles that do not directly relate to individual user access, while C, Server login, is associated with server-level access rather than database-specific access.