An example of denormalization is using a _____ denormalized table to hold report data. This is required when creating a tabular report in which the columns represent data that are stored in the table as rows.
A) transitive
B) 3NF
C) component
D) temporary

Question

Quizplus · Accepted Answer

Denormalization involves intentionally adding redundancy to a database to improve query performance, and using a temporary denormalized table for report data is a common example of this. This temporary table is not meant to be used for normalized storage or modification of data, but simply for generating a specific report. Therefore, the best choice in this scenario would be a temporary denormalized table (choice D).

An Example of Denormalization Is Using a _____ Denormalized Table