CISA Certified Information Systems Auditor – Question2950

The database administrator (DBA) suggests that DB efficiency can be improved by denormalizing some tables. This would result in:

A.
loss of confidentiality.
B. increased redundancy.
C. unauthorized accesses.
D. application malfunctions.

Correct Answer: B

Explanation:

Explanation:
Normalization is a design or optimization process for a relational database (DB) that minimizes redundancy; therefore, denormalization would increase redundancy. Redundancy which is usually considered positive when it is a question of resource availability is negative in a database environment, since it demands additional and otherwise unnecessary data handling efforts.
Denormalization is sometimes advisable for functional reasons. It should not cause loss of confidentiality, unauthorized accesses or application malfunctions.