PrepAway - Latest Free Exam Questions & Answers

You need to ensure that you can copy the database from ABC-SQL1 to ABC-SQL2 and that users can access the data

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?

PrepAway - Latest Free Exam Questions & Answers

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:


Leave a Reply