Home » Microsoft » 70-462 v.2 » What data base setting should you modify?
You have a SQL Server database named DB1.
You plan to load 10 million rows to DB1 by running bcp.exe.
You need to modify DB1 to minimize the amount of space required to store the transaction logs during the load operation. The solution must ensure that you can perform a point-in-time restore.
What data base setting should you modify?
A. Compatibility level to 120
B. Recovery model to Bulk logged
C. Containment type to Partial
D. Recovery model to Simple
Correct Answer: C
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