Certified Information Systems Auditor (CISA) — Question 269

Which of the following will BEST ensure that a proper cutoff has been established to reinstate transactions and records to their condition just prior to a computer system failure?

Answer options

• A. Rotating backup copies of transaction files offsite
• B. Ensuring bisynchronous capabilities on all transmission lines
• C. Maintaining system console logs in electronic format
• D. Using a database management system (DBMS) to dynamically back-out partially processed transactions

Correct answer: D

Explanation

Using a database management system (DBMS) to dynamically back-out partially processed transactions ensures that any incomplete actions can be reverted, maintaining data integrity. The other options, while useful for data protection and recovery, do not directly address the need for a proper cutoff to restore system state just prior to failure.