Microsoft
70-459 · Question #124
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
The correct answer is B. Contained database. 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.
Design and implement database solutions
Question
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.
Options
- ATriggers
- BContained database
- CSQL Server Analysis Services (SSAS) scripts
- DExtended Events
- ESQL Server Integration Services (SSIS) scripts
How the community answered
(21 responses)- B86% (18)
- C10% (2)
- D5% (1)
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.
Topics
#contained databases#SQL Server Authentication#database portability#logins
Community Discussion
No community discussion yet for this question.