nerdexam
Cisco

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.

Security Monitoring

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)
  • A
    3% (1)
  • B
    86% (31)
  • C
    8% (3)
  • E
    3% (1)

Why each option

Data normalization serves security goals by eliminating redundant copies of sensitive data and ensuring data remains accurate and consistent.

Aincrease data exposure

Increasing data exposure directly contradicts security objectives; normalization seeks to reduce unnecessary access and duplication, not expand exposure.

Bpurge redundant dataCorrect

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.

Ccreate data for attraction

Creating data for attraction is not a recognized data management or security concept and has no relationship to normalization principles.

Dmaintain data integrityCorrect

Maintaining data integrity ensures that data remains accurate, complete, and unaltered - a core security principle that guards against unauthorized modification and supports trustworthy records.

Ereduce size of data on disk

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

#data normalization#data integrity#redundant data#security data management

Community Discussion

No community discussion yet for this question.

Full 210-255 Practice