FC0-U71 Data and Database Fundamentals Practice Question
A small retail store keeps its sales records in a spreadsheet file. The owner complains that customer addresses are typed slightly differently in different rows, and that correcting one address requires editing many rows. Which data concept best describes the root problem the owner is experiencing?
⚠ Common exam trap
The trap here is assuming any messy or error-filled data must be a database design fault, when the defining symptom is really the same fact duplicated in multiple rows.
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
✓
Data redundancy with resulting inconsistency
Because the same customer detail is retyped into every sales row, one real-world fact exists in many places at once. That duplication is redundancy, and the divergent spellings are the inconsistency it produces. A structure that stores the customer once and references it from sales rows removes both symptoms.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
A weak wireless network connection to the file share
Why it's wrong here
Network throughput would cause slow saves, timeouts, or failed writes. It would not cause an address to be entered with different spellings in different rows, because each entry is a separate manual keystroke. The described symptom is a content and consistency problem, not a connectivity problem.
- ✗
Insufficient storage capacity on the workstation
Why it's wrong here
The owner is not reporting that files will not fit or that the disk is full. The complaint is about the same address appearing in several forms and about the effort of updating many rows. Storage capacity has no bearing on whether duplicated values agree with each other, so it does not describe this problem.
- ✓
Data redundancy with resulting inconsistency
Why this is correct
The same customer address is stored repeatedly across many rows, so the same fact is duplicated. When one copy is corrected, the other copies still hold the old value, producing inconsistent data. This duplication of the same fact in multiple places is exactly what redundancy means, and the mismatched addresses are the resulting inconsistency.
- ✗
Missing antivirus definitions on the store's computer
Why it's wrong here
Malware protection has nothing to do with how addresses are typed into cells. Even a fully patched machine with current definitions would still show duplicated, disagreeing addresses if the same customer detail is retyped in every sales row. The scenario points to how data is stored, not to endpoint security.
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 and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official CompTIA exam blueprint
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.