The Greatest Risk in Data Normalization - CISA Exam Insights

A.

Data normalization is the process of organizing data in a database so that it is consistent, accurate, and efficient. It involves decomposing a large table into smaller tables to eliminate redundancy and improve data integrity. While data normalization offers numerous benefits, it also presents some risks.

Of the options provided, the greatest risk when performing data normalization is decreased performance (option D). This is because normalization typically results in an increase in the number of tables in a database, which can lead to increased complexity and slower query performance. When a query involves multiple tables that are joined together, the database must perform more operations to retrieve the data, which can be time-consuming and resource-intensive.

While option A (increased complexity of the data model) is a risk associated with data normalization, it is not as significant as the risk of decreased performance. The increased complexity of the data model may make it more difficult to understand and maintain, but it does not necessarily have a direct impact on performance.

Option B (duplication of audit logs) is not a risk associated with data normalization. Audit logs are used to track changes to data and are not affected by the process of data normalization.

Option C (reduced data redundancy) is actually a benefit of data normalization, not a risk. By eliminating redundant data, data normalization helps to ensure data consistency and accuracy, which can improve the overall quality of data in a database.

In summary, the greatest risk when performing data normalization is decreased performance (option D). While increased complexity of the data model (option A) is a risk, it is not as significant as the risk of decreased performance. Duplication of audit logs (option B) is not a risk associated with data normalization, and reduced data redundancy (option C) is actually a benefit.