Why would a database be denormalized?

Why would a database be denormalized?

Why would a database be denormalized?

A.
To ensure data integrity

B.
To increase processing efficiency

C.
To prevent duplication of data

D.
To save storage space

Explanation:
The purpose of denormalization is to improve the read performance and processing efficiency of a database by
adding redundant data or by grouping data.
Incorrect Answers:
A: The duplication of data creates a problem for data integrity as the data needs to be updated in numerous
places. Normalization, which eliminates the duplication of data, improves data integrity.
C: The purpose of normalization is to eliminate duplication of the data. All duplicated data items should be
deleted and replaced by a pointer. Denormalization could reverse this process. It attempts to improve the read
performance and processing efficiency of a database by adding redundant data or by grouping data.
D: The purpose of denormalization is to improve the read performance and processing efficiency of a database
by adding redundant data or by grouping data. This increases storage space consumption.

https://en.wikipedia.org/wiki/Denormalization
https://en.wikipedia.org/wiki/Database_normalization
Miller, David R., CISSP Training Kit, O’Reilly Media, Sebastopol, 2013, pp. 620, 622



Leave a Reply 0

Your email address will not be published. Required fields are marked *