What is a likely consequence of data redundancy in a database?

Data redundancy in a database refers to the unnecessary duplication of data across the system. This situation typically leads to increased storage costs because the same data is being stored in multiple locations, which consumes additional storage resources. Each instance of the duplicated data requires physical disk space, thus raising the overall costs associated with data storage solutions.

In contrast, while poor data integrity and increased chances of inconsistencies may arise from redundancy, the main and most immediate consequence is the expense linked to the surplus storage requirements. Additionally, performance issues may follow, but these are a secondary concern compared to the financial implications of maintaining redundant data. Enhanced query performance is generally not a result of redundancy, as duplicated data can complicate data retrieval and may lead to inefficiencies.

Therefore, increased storage costs directly showcase the financial burden that can come with managing redundant data and highlight a significant drawback of poor database design.