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