Exam 70-462 topic 2 question 203 discussion

Actual exam question from Microsoft's 70-462

Question #: 203
Topic #: 2

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 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.

Show Suggested Answer

Suggested Answer: BC 🗳️
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-a-partially-contained-database

by RGataullin at April 19, 2020, 8:44 p.m.

Comments

Submit Cancel

Deju

4 years, 9 months ago

The correct answer should be CE; NOT BC Contained databases must be enabled on the instance of the SQL Server Database Engine before contained databases can be created. Enabling Contained Databases Using Transact-SQL The following example enables contained databases on the instance of the SQL Server Database Engine. SQL Copy sp_configure 'contained database authentication', 1; GO RECONFIGURE ; GO Enabling Contained Databases Using Management Studio The following example enables contained databases on the instance of the SQL Server Database Engine. In Object Explorer, right-click the server name, and then click Properties. On the Advanced page, in the Containment section, set the Enable Contained Databases option to True. Click OK.

upvoted 1 times

...

RGataullin

5 years, 2 months ago

It is not a database property. It is an instance property. Shouldn't the answer be EC? https://docs.microsoft.com/en-us/sql/relational-databases/databases/migrate-to-a-partially-contained-database?view=sql-server-ver15

upvoted 2 times

...