Administering Microsoft SQL Server 2012/2014 Databases — Question 39

You administer a Microsoft SQL Server environment. One of the SQL Server instances contains a database named Contoso.
You plan to migrate Contoso to Microsoft Azure SQL Database.
To do so, you need to implement a contained database.
Which two actions should you perform? Each correct answer presents part of the solution.

Answer options

• A. Set database containment to CONTAINED.
• B. Enable database property contained database authentication.
• C. Set database containment to PARTIAL.
• D. Set database containment to CLOUD.
• E. Enable server property contained database authentication.
• F. Enable database property encryption enabled.

Correct answer: B, C

Explanation

The correct answers are B and C because enabling contained database authentication (B) and setting database containment to PARTIAL (C) are necessary for creating a contained database in SQL Server. Option A is incorrect as CONTAINED is not a valid containment level; options D and E are irrelevant to the specific requirements for migrating to Azure SQL Database, and F is not needed for containment.