CISA Certified Information Systems Auditor – Question0888

Why would a database be renormalized?

A.
To ensure data integrity
B. To increase processing efficiency
C. To prevent duplication of data
D. To save storage space

Correct Answer: B

Explanation:

Explanation: A database is renormalized when there is a need to improve processing efficiency. There is, however, a risk to data integrity when this occurs. Since it implies the introduction of duplication, it will not likely allow saving of storage space. Reference: Information Systems Audit and Control Association, Certified Information Systems Auditor 2002 review manual, Chapter 3: Technical Infrastructure and Operational Practices (page 109).