Certified Information Systems Auditor (CISA) — Question 977

Which of the following provides the BEST assurance that a new process for purging transactions does not have a detrimental impact on the integrity of the database?

Answer options

• A. Reviewing the entity relationship diagram of the database
• B. Reviewing results of the process in a test environment
• C. Assessing the design of triggers
• D. Analyzing the database structure

Correct answer: B

Explanation

The correct choice, B, emphasizes testing the process in a controlled environment to observe its effects, ensuring any potential issues can be identified before implementation. Options A, C, and D involve theoretical assessments that do not provide practical insights into how the actual process will perform, making them less effective in guaranteeing database integrity.