Exam 70-764 topic 1 question 94 discussion

Actual exam question from Microsoft's 70-764

Question #: 94
Topic #: 1

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

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.

Show Suggested Answer

Suggested Answer: BD 🗳️

by TheSwedishGuy at Jan. 28, 2020, 11:36 a.m.

Comments

Submit Cancel

TheSwedishGuy

5 years, 5 months ago

A contained database is a database that is isolated from other databases and from the instance of SQL Server that hosts the database. With partial containment, it's possible to migrate the database to Azure. Also, you have to enable database level authentication at the server level.

upvoted 1 times

TheSwedishGuy

5 years, 5 months ago

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.

upvoted 1 times

...