FC0-U71 Data and Database Fundamentals Practice Question
A database designer wants to split a table into two to reduce data redundancy and avoid update anomalies. This process is known as:
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
✓
Normalization
Normalization is the process of organizing data to reduce redundancy and improve integrity.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Normalization
Why this is correct
Normalization splits tables to eliminate redundancy.
- ✗
Denormalization
Why it's wrong here
Denormalization deliberately reintroduces redundancy by merging tables, the opposite of the required change. It is tempting because it improves read performance in reporting and analytics workloads, where joining many normalized tables is costly, but it worsens the update anomalies described.
- ✗
Indexing
Why it's wrong here
Indexing builds lookup structures over existing columns; it leaves the table's schema and duplicate values untouched, so update anomalies persist. It is tempting because indexes genuinely speed up query retrieval on large tables, and would be the right answer if the scenario asked how to accelerate searches rather than reorganise data.
- ✗
Partitioning
Why it's wrong here
Partitioning divides one table's rows across storage segments by a key range or list, leaving the same columns intact, so it cannot remove redundancy or update anomalies. It is tempting because it also splits a table, and would be correct when the goal is query pruning or managing very large tables.
Go deeper
Related to this question
About these practice questions
This FC0-U71 question is part of Courseiva's 988-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam 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 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.