Correct Answer: B
Explanation/Reference:
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.
References:
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