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