FC0-U71 Data and Database Fundamentals Practice Question
Which of the following is a valid reason to use a database instead of a spreadsheet?
⚠ Common exam trap
The trap is picking a subjective or false option (harder to learn, always free, cannot store numbers) instead of the technical capability — query power and integrity enforcement — that actually distinguishes databases from spreadsheets.
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
✓
Databases provide query capabilities and enforce data integrity
Databases provide structured query languages (SQL) for complex data retrieval and enforce data integrity through constraints like primary keys, foreign keys, and data types. These capabilities prevent duplicate or orphaned records and enable powerful multi-table queries that spreadsheets cannot reliably match at scale. This is the core reason to choose a database over a spreadsheet.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Spreadsheets cannot store numbers
Why it's wrong here
Spreadsheets store numbers perfectly well; numeric cells, formulas and charts are core features. Databases are chosen for enforced schemas, relational integrity and concurrent access at scale. This option would fit a question about unstructured content or text-only storage, which is not the actual distinction.
- ✗
Spreadsheets are harder to learn
Why it's wrong here
Ease of learning is not a technical capability difference; spreadsheets are widely considered approachable. Databases are chosen for relational integrity, concurrent multi-user access and query scale. This option would suit a question about training overhead or user adoption, not data management suitability.
- ✓
Databases provide query capabilities and enforce data integrity
Why this is correct
Databases support structured querying via SQL and enforce integrity through constraints such as primary keys, foreign keys and data types. Spreadsheets lack these guarantees, so they suit smaller, less critical datasets where concurrent access and validation are not required.
- ✗
Databases are always free
Why it's wrong here
Cost is not the defining criterion; many database platforms carry licence or hosting fees, and spreadsheets are not universally free either. Databases are selected for data integrity, concurrency and query capability. This option would suit a procurement or licensing question, not one about storage technology suitability.
Go deeper
Related to this question
About these practice questions
Courseiva writes every FC0-U71 question from scratch — 988 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 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.