You administer a Microsoft SQL Server 2012 environment. One of the SQL Server 2012 instances contains a
database named Sales.
You plan to migrate Sales to Windows Azure SQL Database.
To do so, you need to implement a contained database.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)
A.
Set database containment to AZURE.
B.
Enable server property contained database authentication.
C.
Disable server property cross db ownership chaining.
D.
Set database containment to PARTIAL.
E.
Disable server property contained database authentication.
F.
database containment to FULL.
Explanation:
A contained database is a database that is isolated from other databases and from the instance of SQL Server
that hosts the database.
B: In the contained database user model, the login in the master database is not present. Instead, the
authentication process occurs at the user database, and the database user in the user database does not have
an associated login in the master database.
SQL Database and SQL Data Warehouse support Azure Active Directory identities as contained databaseusers.
D: The contained database feature is currently available only in a partially contained state. A partially contained
database is a contained database that allows the use of uncontained features.
https://docs.microsoft.com/en-us/sql/relational-databases/databases/contained-databases