You work as a senior database administrator at ABC.com. The ABC.com network consists of a
single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their
environment.
You are running a training exercise for Microsoft SQL Server 2012 junior administrators. You are
discussing contained databases.
Which of the following is TRUE with regards to contained databases? (Choose all that apply.)
A.
Users are prevented from updating the information in contained objects directly.
B.
It is isolated from other databases and from the instance of SQL Server that hosts the
database.
C.
The MSDB database is an example of a contained database.
D.
It includes all the settings and metadata necessary to define the database and has no
configuration dependencies on the instance of the SQL Server Database Engine where the
database is installed.
Explanation: