nerdexam
Cisco

210-255 · Question #198

Which two goals of data normalization are true? (Choose two.)

The correct answer is B. Eliminate redundant data. C. Increase integrity of 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.

How the community answered

(30 responses)
  • A
    7% (2)
  • B
    87% (26)
  • D
    3% (1)
  • E
    3% (1)

Why each option

Database normalization is a design process primarily aimed at eliminating redundant data and improving data integrity by structuring tables to minimize inconsistency.

AEliminate update anomalies.

Eliminating update anomalies is a consequence that results from eliminating redundancy, not an independently stated primary goal of normalization itself.

BEliminate redundant data.Correct

A core goal of normalization is to ensure each fact is stored in exactly one place, eliminating redundant data and preventing storage waste and update inconsistencies across duplicate fields.

CIncrease integrity of data.Correct

By removing redundancy and enforcing proper dependencies, normalization increases data integrity - ensuring that inserts, updates, and deletes do not leave the database in an inconsistent or contradictory state.

DIncrease redundancy of data.

Increasing redundancy is the opposite of normalization - denormalization or replication strategies intentionally add redundancy for performance or availability reasons.

EIncrease data availability.

Data availability is addressed through high-availability architectures, clustering, and replication - not through the normalization process.

Concept tested: Database normalization goals - redundancy and integrity

Source: 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.

Full 210-255 Practice