mediumMultiple SelectObjective-mapped
FC0-U71 Practice Question: Which THREE of the following are best practices…
Which THREE of the following are best practices for database normalization? (Choose three.)
⚠ Common exam trap
The FC0-U61 exam often tests the misconception that normalization means creating many small tables (one per attribute), when in fact it requires grouping attributes by their functional dependencies to eliminate redundancy without over-fragmentation.
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
✓
Eliminate redundant data
Eliminating redundant data is a core goal of database normalization because it reduces storage requirements and prevents data inconsistencies. By ensuring each piece of data is stored in only one place, you avoid update anomalies that occur when the same fact is recorded in multiple rows or tables. This practice directly supports the second normal form (2NF) and third normal form (3NF) objectives of removing partial and transitive dependencies.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Use composite primary keys excessively
Why it's wrong here
Excessive composite keys can complicate design; normalization does not require them.
- ✓
Eliminate redundant data
Why this is correct
Redundancy causes anomalies; normalization removes it.
- ✓
Ensure data dependencies make sense
Why this is correct
Functional dependencies should reflect real-world relationships.
- ✓
Reduce update anomalies
Why this is correct
One main goal of normalization is to minimize update anomalies.
- ✗
Create separate tables for each attribute
Why it's wrong here
This is over-normalization and impractical.
Go deeper
Related to this question
About these practice questions
One of 988 original FC0-U71 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This FC0-U71 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 FC0-U71 exam.