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

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.