DA0-002 Data Concepts and Environments Practice Question
Which TWO of the following are benefits of database normalization to 3NF? (Select 2)
⚠ Common exam trap
It's easy for candidates to confuse normalization with denormalization, assuming that reducing redundancy always improves query performance, when in fact normalization often increases join complexity and can slow down read queries.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Reduces data redundancy
Normalization to 3NF eliminates transitive dependencies, which directly reduces data redundancy by ensuring each non-key attribute depends only on the primary key. This reduction in redundancy also increases data integrity because updates, inserts, and deletes are less likely to create inconsistencies or anomalies. In a relational database, 3NF achieves this without sacrificing the ability to reconstruct the original data via joins.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Improves query performance for all queries
Why it's wrong here
Normalization can increase joins, potentially slowing queries.
- ✓
Reduces data redundancy
Why this is correct
Normalization eliminates duplicate data.
- ✗
Simplifies complex joins
Why it's wrong here
Normalization often increases number of joins.
- ✗
Eliminates all data anomalies
Why it's wrong here
Normalization reduces but does not eliminate all anomalies.
- ✓
Increases data integrity
Why this is correct
Integrity constraints prevent anomalies.
Go deeper
Related to this question
About these practice questions
Courseiva writes every DA0-002 question from scratch — 986 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DA0-002 practice question is part of Courseiva's free CompTIA certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DA0-002 exam.