Which of the following is a potential drawback of denormalization?

  • Enhanced query performance
  • Improved data integrity
  • Increased risk of data inconsistency
  • Reduced storage space
One potential drawback of denormalization is the increased risk of data inconsistency. Denormalizing tables may lead to duplicated data across the database, making it more challenging to maintain data consistency. Changes to data in one location may not be reflected in all duplicated instances, resulting in inconsistencies. Thus, careful consideration is needed while denormalizing to balance performance benefits with the risk of data inconsistency. 
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *