Certified Internal Auditor (CIA) Part 3: Business Knowledge for Internal Auditing — Question 205

Which of the following backup methodologies would be most efficient in backing up a database in the production environment?

Answer options

• A. Disk mirroring of the data being stored on the database.
• B. A differential backup that is performed on a weekly basis.
• C. An array of independent disks used to back up the database.
• D. An incremental backup of the database on a daily basis.

Correct answer: D

Explanation

An incremental backup, which is conducted daily, efficiently saves changes made since the last backup, minimizing storage use and backup time. In contrast, disk mirroring continuously duplicates data, which can be resource-intensive, while differential backups accumulate changes over the week, leading to larger backups. An array of independent disks does not specifically address backup frequency or efficiency.