210-255 · Question #74
Which of the following is one of the main goals of data normalization?
The correct answer is B. To purge redundant data while maintaining data integrity. Data normalization is a database design process aimed at eliminating redundant data while preserving data integrity through structured organization.
Question
Which of the following is one of the main goals of data normalization?
Options
- ATo save duplicate logs for redundancy
- BTo purge redundant data while maintaining data integrity
- CTo correlate IPS and IDS logs with DNS
- DTo correlate IPS/IDS logs with firewall logs
How the community answered
(47 responses)- A4% (2)
- B91% (43)
- C2% (1)
- D2% (1)
Why each option
Data normalization is a database design process aimed at eliminating redundant data while preserving data integrity through structured organization.
Saving duplicate logs for redundancy is the opposite of normalization - it introduces the very redundancy that normalization is designed to eliminate.
Normalization applies a set of rules (normal forms) to a relational database schema to remove duplicate or redundant data, reduce anomalies, and ensure that data integrity is maintained through proper relationships and constraints. The goal is efficient, non-redundant storage - not log aggregation or correlation.
Correlating IPS/IDS logs with DNS records is a log analysis or SIEM correlation task, unrelated to database normalization.
Correlating IPS/IDS logs with firewall logs is also a log correlation function performed by SIEM tools, not a goal of data normalization.
Concept tested: Database normalization purpose and goals
Source: https://learn.microsoft.com/en-us/office/troubleshoot/access/database-normalization-description
Topics
Community Discussion
No community discussion yet for this question.