nerdexam
Microsoft

70-465 · Question #112

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. Select the BEST answer.

The correct answer is B. Database user. When moving a database between servers, contained database users allow authentication at the database level without requiring matching server-level logins on the destination server, minimizing administrative effort.

Submitted by zhang_li· Mar 5, 2026Design database security solutions

Question

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. Select the BEST answer.

Options

  • AApplication role
  • BDatabase user
  • CServer login
  • DServer role

How the community answered

(28 responses)
  • B
    93% (26)
  • C
    4% (1)
  • D
    4% (1)

Why each option

When moving a database between servers, contained database users allow authentication at the database level without requiring matching server-level logins on the destination server, minimizing administrative effort.

AApplication role

Application roles are used to grant specific permissions to applications rather than to authenticate end users, and they do not solve the portability problem when moving a database between servers.

BDatabase userCorrect

Database users, specifically contained database users, store authentication credentials within the database itself rather than relying on server-level logins. When the database is moved to a new server, the users and their credentials travel with the database, eliminating the need to recreate server logins and remap user SIDs on the destination server.

CServer login

Server logins are defined at the instance level and do not travel with the database when it is moved; on the new server, orphaned users would result because the SIDs of the logins may not match, requiring manual remapping effort.

DServer role

Server roles are instance-level security principals used to group server-level permissions and do not move with the database, so they provide no benefit for ensuring user access after a database migration.

Concept tested: Contained database users for cross-server database portability

Source: https://learn.microsoft.com/en-us/sql/relational-databases/security/contained-database-users-making-your-database-portable

Topics

#Database users#Login migration#Security management

Community Discussion

No community discussion yet for this question.

Full 70-465 Practice