210-255 · Question #149
Which are two security goals of data normalization? (Choose two.)
The correct answer is B. purge redundant data D. maintain data integrity. Data normalization serves security goals by eliminating redundant copies of sensitive data and ensuring data remains accurate and consistent.
Question
Which are two security goals of data normalization? (Choose two.)
Options
- Aincrease data exposure
- Bpurge redundant data
- Ccreate data for attraction
- Dmaintain data integrity
- Ereduce size of data on disk
How the community answered
(36 responses)- A3% (1)
- B86% (31)
- C8% (3)
- E3% (1)
Why each option
Data normalization serves security goals by eliminating redundant copies of sensitive data and ensuring data remains accurate and consistent.
Increasing data exposure directly contradicts security objectives; normalization seeks to reduce unnecessary access and duplication, not expand exposure.
Purging redundant data reduces the attack surface by minimizing unnecessary copies of sensitive information, decreasing the number of locations an attacker could target or exfiltrate data from.
Creating data for attraction is not a recognized data management or security concept and has no relationship to normalization principles.
Maintaining data integrity ensures that data remains accurate, complete, and unaltered - a core security principle that guards against unauthorized modification and supports trustworthy records.
Reducing disk size may be an incidental side effect of normalization, but it is an operational benefit rather than a security goal.
Concept tested: Security goals of database normalization
Source: https://learn.microsoft.com/en-us/office/troubleshoot/access/database-normalization-description
Topics
Community Discussion
No community discussion yet for this question.