You need to ensure that when the new database is copied from SQLProd to SQLDev, users can connect to the database on SQLDev even if they do not have a login on the SQLDev instance

You have two SQL Server 2014 instances named SQLDev and SQLProd.
You plan to create a new database on SQLProd that will use SQL Server Authentication.
You need to ensure that when the new database is copied from SQLProd to SQLDev, users
can connect to the database on SQLDev even if they do not have a login on the SQLDev
instance.
What should you use?
More than one answer choice may achieve the goal. Select the BEST answer.

You have two SQL Server 2014 instances named SQLDev and SQLProd.
You plan to create a new database on SQLProd that will use SQL Server Authentication.
You need to ensure that when the new database is copied from SQLProd to SQLDev, users
can connect to the database on SQLDev even if they do not have a login on the SQLDev
instance.
What should you use?
More than one answer choice may achieve the goal. Select the BEST answer.

A.
Triggers

B.
Contained database

C.
SQL Server Analysis Services (SSAS) scripts

D.
Extended Events

E.
SQL Server Integration Services (SSIS) scripts

Explanation:

A fully contained database includes all the settings and metadata required to define the
database and has no configuration dependencies on the instance of the SQL Server
Database Engine where the database is installed.



Leave a Reply 2

Your email address will not be published. Required fields are marked *