210-255 · Question #43
Which goal of data normalization is true?
The correct answer is A. Reduce data redundancy.. Data normalization is a database design process that eliminates redundant data by organizing tables and relationships efficiently.
Question
Which goal of data normalization is true?
Options
- AReduce data redundancy.
- BIncrease data redundancy.
- CReduce data availability.
- DIncrease data availability
How the community answered
(68 responses)- A94% (64)
- B3% (2)
- C1% (1)
- D1% (1)
Why each option
Data normalization is a database design process that eliminates redundant data by organizing tables and relationships efficiently.
The primary goal of data normalization is to reduce data redundancy by decomposing tables into smaller, well-structured relations and establishing proper foreign key relationships, which also improves data integrity and minimizes update anomalies.
Increasing data redundancy is the opposite of normalization and is instead associated with denormalization, which trades storage efficiency for read performance.
Normalization has no direct goal of reducing data availability; it is concerned with structure and consistency, not access.
Increasing data availability is a concern of high-availability architectures such as replication and clustering, not normalization.
Concept tested: Database normalization goals and principles
Source: https://learn.microsoft.com/en-us/office/troubleshoot/access/database-normalization-description
Topics
Community Discussion
No community discussion yet for this question.