CISA Certified Information Systems Auditor – Question1684

What is the BEST backup strategy for a large database with data supporting online sales?

A.
Weekly full backup with daily incremental backup
B. Daily full backup
C. Clustered servers
D. Mirrored hard disks

Correct Answer: A

Explanation:

Explanation:
Weekly full backup and daily incremental backup is the best backup strategy; it ensures the ability to recover the database and yet reduces the daily backup time requirements. A full backup normally requires a couple of hours, and therefore it can be impractical to conduct a full back up every day. Clustered servers provide a redundant processing capability, but are not a backup.
Mirrored hard disks will not help in case of disaster.