Explanation/Reference:
Explanation:
A contained database is a database that is isolated from other databases and from the instance of SQL Server that hosts the database.
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.
Incorrect Answers:
A: To change the compatibility level, select a different option from the list. The choices are SQL Server
2008 (100), SQL Server 2012 (110), or SQL Server 2014 (120).
B: Point-in-time recovery is not supported in the Bulk logged recovery model.
D: The Simple recovery model does not support Point-in-time restores
References: https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/recovery-models- sql-server
https://docs.microsoft.com/en-us/sql/relational-databases/databases/contained-databases?view=sql- server-2017