Administering a SQL Database Infrastructure — Question 117

You administer a Microsoft SQL Server 2016 environment.
One of the SQL Server 2016 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.)

Answer options

• 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. Set database containment to FULL.

Correct answer: B, D

Explanation

The correct answers are B and D because enabling contained database authentication (B) is essential for creating a contained database, and setting the containment to PARTIAL (D) is required for a database to be considered contained. Options A, C, E, and F are either incorrect or not necessary for this specific migration process.