WHEN YOU ARE PERFORMING A MINIMALLY LOGGED BULK OPERATION AGAINST A...

7. When you are performing a minimally logged bulk operation against a data-base using the BULK_LOGGED recovery model, what must you do after the bulk operation completes to ensure your ability to recover the database?A. Change the database recovery model to FULLB. Change the database recovery model to SIMPLEC. Truncate the transaction logD. Backup the transaction logCorrect Answer and Explanation: D. Answer D is the correct answer. When you back up a transaction log that includes information about minimally logged bulk operations, the actual data that was modified as part of the bulk operation is included in the backup of the log, even if it wasn’t included in the live log. By backing up the transaction log after a minimally logged bulk operation, you ensure that you have full details about the bulk operation backed up, and can therefore restore the database to a point after the bulk operation in the event of a catastrophic failure.Incorrect Answers and Explanations: A, B, and C. Answers A and B are incorrect. They simply change how new transactions will be handled in the transaction log. They do not help you recover previous transactions should the database become corrupt. Answer C is incorrect because it would remove any record of the bulk operation having occurred from the log. This would most certainly not help you recover the database after a failure.