What is the process in which there is redundancy of data to improve performance?

The correct answer is C. Denormalization. Denormalization is the process of intentionally backing away from normalization to improve performance by suppressing join and permitting the use of star transformation technique. Denormalization should not be the first choice for improving performance and should only be used…

Developing the Physical Layer of a Repository

Question

Options

ARedundancy
BNormalization
CDenormalization
DGranularity
ECardinality

How the community answered

(48 responses)

A
2% (1)
B
4% (2)
C
83% (40)
D
8% (4)
E
2% (1)

Explanation

Denormalization is the process of intentionally backing away from normalization to improve performance by suppressing join and permitting the use of star transformation technique. Denormalization should not be the first choice for improving performance and should only be used for fine tuning of a database for a particular application.

Topics

#denormalization#data redundancy#performance#data modeling

Community Discussion

No community discussion yet for this question.

Full 1Z0-591 Practice