Administering a SQL Database Infrastructure — Question 145

You have two SQL Server 2012 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 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.

Answer options

• A. SQL Server Integration Services (SSIS) scripts
• B. Extended Events
• C. Triggers
• D. SQL Server Analysis Services (SSAS) scripts
• E. Contained database

Correct answer: E

Explanation

The best answer is E, as a contained database allows the database to manage its own users and permissions independently of the SQL Server instance, ensuring that users can connect even if they do not have a corresponding login on SQLDev. The other options, such as SSIS scripts and SSAS scripts, do not provide the necessary user management features required for this scenario.