Your role as a Database Administrator (DBA) at ABC.com includes the management of the
Microsoft SQL Server 2012 database server infrastructure. All servers are members of a
single Active Directory Domain Services (AD DS) domain named ABC.com.
A database server named ABC-SQL1 runs Microsoft SQL Server 2012. You plan to create a
database on ABC-SQL1. Database users have logins configured on ABC-SQL1. The
database will be configured to use SQL Server 2012 authentication.
A recently installed database server named ABC-SQL2 also runs Microsoft SQL Server
2012. Only the default logins have been created on ABC-SQL2.
You need to ensure that you can copy the database from ABC-SQL1 to ABC-SQL2 and that
users can access the database without the need to configure logins for the users.
What should you do?
A.
You should configure Active Directory user accounts.
B.
You should create a contained database.
C.
You should create a user role on ABC-SQL2.
D.
You should configure Multiserver Job Processing.
Explanation: