Multiple choice technology web technology

You use the bcp utility to import data during nonworking hours. After importing data into the database, you execute a full backup statement. You need to ensure that the impact on the database during the insert is reduced to a minimum. Which of the following options can help you achieve that?

  1. Set the recovery model to Full

  2. Set the recovery model to Simple

  3. Set the recovery model to Bulk-Logged

  4. Back up the transaction log while performing the inserts

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The Bulk-Logged recovery model minimizes transaction log overhead during bulk operations like bcp imports by logging only the extent allocations rather than each row change. This reduces the performance impact while still allowing point-in-time recovery (unlike Simple recovery, which doesn't support transaction log backups). Full recovery would log every row individually, causing maximum overhead.