PrepAway - Latest Free Exam Questions & Answers

This situation will increase the risk of:

A database administrator has detected a performance problem with some tables which
could be solved through denormalization. This situation will increase the risk of:

PrepAway - Latest Free Exam Questions & Answers

A.
concurrent access.

B.
deadlocks.

C.
unauthorized access to data.

D.
a loss of data integrity.

Explanation:

Normalization is the removal of redundant data elements from the database structure. Disabling
normalization in relational databases will create redundancy and a risk of not maintaining
consistency of data, with the consequent loss of data integrity. Deadlocks are not caused by
denormalization. Access to data is controlled by defining user rights to information, and is not
affected by denormalization.


Leave a Reply