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.
A . Set database containment to CONTAINE
C . Enable database property contained database authentication.
D . Set database containment to PARTIA
F . Set database containment to CLOU
H . Enable server property contained database authentication.
. Enable database property encryption enabled.
Answer: B,C
Explanation:
Contained database authentication is defined on the database, not on the server.
A database is converted to a contained database by changing the CONTAINMENT option to partial.
References: https://docs.microsoft.com/en-us/sql/relational-databases/databases/migrate-to-apartially-contained-database