Cisco
210-255 · Question #198
210-255 Question #198: Real Exam Question with Answer & Explanation
The correct answer is B: Eliminate redundant data.. Database normalization is a design process primarily aimed at eliminating redundant data and improving data integrity by structuring tables to minimize inconsistency.
Security Monitoring
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.
Explanation
Database normalization is a design process primarily aimed at eliminating redundant data and improving data integrity by structuring tables to minimize inconsistency.
Common mistakes.
- A. Eliminating update anomalies is a consequence that results from eliminating redundancy, not an independently stated primary goal of normalization itself.
- D. Increasing redundancy is the opposite of normalization - denormalization or replication strategies intentionally add redundancy for performance or availability reasons.
- E. Data availability is addressed through high-availability architectures, clustering, and replication - not through the normalization process.
Concept tested. Database normalization goals - redundancy and integrity
Reference. https://learn.microsoft.com/en-us/office/troubleshoot/access/database-normalization-description
Topics
#data normalization#log management#data integrity#redundancy elimination
Community Discussion
No community discussion yet for this question.