210-255 Question #149: Real Exam Question with Answer & Explanation

The correct answer is B: purge redundant data. 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

Explanation

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

Common mistakes.

A. Increasing data exposure directly contradicts security objectives; normalization seeks to reduce unnecessary access and duplication, not expand exposure.
C. Creating data for attraction is not a recognized data management or security concept and has no relationship to normalization principles.
E. 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

Reference. https://learn.microsoft.com/en-us/office/troubleshoot/access/database-normalization-description

Community Discussion

No community discussion yet for this question.

Full 210-255 Practice