00 P.M. GIVE THIS BACKUP TO THE COMPLIANCE OFFICER.D. TAKE A PARTIAL B...

1:00 p.m. Give this backup to the compliance officer.D. Take a partial backup written to the special media on Sunday at 1:00 p.m. Give this backup to the compliance officer.Correct Answer & Explanation: B. The copy-only backup is similar to a full backup but does not change the last backup timestamp. This means that all differential backups will be based on the last full backup and all incremental backups will be based either on the last full or the last differential backup. This will preserve the current backup mechanism and will fall within the light user activity period on Sunday (the copy backup will take the same amount of time as the full backup does).Incorrect Answers & Explanations: A, C, and D. Answer A is incorrect because all differential and Monday and Tuesday’s incremental backups will be taken off the compliance-related full backup, which will not be accessible if you need to perform a restore. Answer C is incorrect because the incremental backup will not provide the compliance officer with a backup that can be restored. Additionally, by doing this you will invalidate Monday and Tuesday’s incremental log backups. Answer D is incorrect because a partial backup will not provide the compliance officer with a backup that can be restored.

Chapter 8: ETL Techniques