Administering Microsoft SQL Server 2012/2014 Databases — Question 45

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?

Answer options

• 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

The correct answer is C, as changing the containment type to Partial allows you to reduce transaction log usage while maintaining the capability for point-in-time recovery. Option A is irrelevant to transaction log space, and options B and D do not meet the requirement for point-in-time restoration during large data loads.