WHEN DOING A BULK INSERT OPERATION YOU RECEIVE AN ERROR STATING THA...

5. When doing a BULK INSERT operation you receive an error stating that the transaction log for the database is full. What can you do to make the BULK INSERT succeed (Select all that apply)?A. Set the database’s recovery model to BULK_LOGGEDB. Run the BULK INSERT with the TABLOCK optionC. Set the database’s recovery model to FULLD. Use BCP instead of BULK INSERTCorrect Answer and Explanation: A and B. Answers A and B combined are the correct answer. Setting the database recovery model to BULK_LOGGED allows SQL Server to record only minimal details in the log. Using the TABLOCK option is also required for minimally logged bulk operations.Incorrect Answers and Explanations: C and D. Answer C is incorrect because the FULL recovery model requires that every record inserted by a bulk operation be completely logged. This is probably why the log is filling in the first place. Answer D is incorrect because BCP performs the same operation as BULK INSERT. Simply using BCP instead of BULK INSERT would have no effect.