210-255 · Question #198
Which two goals of data normalization are true? (Choose two.)
The correct answer is B. Eliminate redundant data. C. Increase integrity of data.. Database normalization is a design process primarily aimed at eliminating redundant data and improving data integrity by structuring tables to minimize inconsistency.
Question
Which two goals of data normalization are true? (Choose two.)
Options
- AEliminate update anomalies.
- BEliminate redundant data.
- CIncrease integrity of data.
- DIncrease redundancy of data.
- EIncrease data availability.
How the community answered
(30 responses)- A7% (2)
- B87% (26)
- D3% (1)
- E3% (1)
Why each option
Database normalization is a design process primarily aimed at eliminating redundant data and improving data integrity by structuring tables to minimize inconsistency.
Eliminating update anomalies is a consequence that results from eliminating redundancy, not an independently stated primary goal of normalization itself.
A core goal of normalization is to ensure each fact is stored in exactly one place, eliminating redundant data and preventing storage waste and update inconsistencies across duplicate fields.
By removing redundancy and enforcing proper dependencies, normalization increases data integrity - ensuring that inserts, updates, and deletes do not leave the database in an inconsistent or contradictory state.
Increasing redundancy is the opposite of normalization - denormalization or replication strategies intentionally add redundancy for performance or availability reasons.
Data availability is addressed through high-availability architectures, clustering, and replication - not through the normalization process.
Concept tested: Database normalization goals - redundancy and integrity
Source: https://learn.microsoft.com/en-us/office/troubleshoot/access/database-normalization-description
Topics
Community Discussion
No community discussion yet for this question.