FC0-U71 Data and Database Fundamentals Practice Question
A student is comparing storage technologies for a project. The student needs a system that stores data as key-value pairs and is designed to scale horizontally across many servers for very high read and write throughput. Which category of database best fits this requirement?
⚠ Common exam trap
The trap here is equating high scalability with any modern database, when actually relational and analytical systems optimize for structure and reporting rather than simple high-throughput key lookups.
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
✓
A key-value NoSQL database.
Key-value NoSQL databases store data as simple key-to-value pairs and are purpose-built to scale horizontally across many servers, delivering the high read and write throughput the student needs. Relational databases, flat files, and analytical warehouses each optimize for different workloads that do not match this requirement.
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 key-value NoSQL database.
Why this is correct
This is correct because key-value stores model data as simple key-to-value pairs and are built for horizontal scaling, distributing keys across nodes to handle very high read and write volumes. They favor availability and partition tolerance over complex joins. This directly matches the student's need for a scalable, high-throughput store.
- ✗
A data warehouse optimized for complex analytical reporting queries.
Why it's wrong here
A data warehouse is tuned for large analytical scans and aggregations over historical data, not for high-volume transactional key-value reads and writes. Its columnar or star-schema design favors reporting workloads. Using it for simple high-throughput key lookups would be inefficient, so it does not fit this scenario.
- ✗
A flat file such as a spreadsheet stored on a shared drive.
Why it's wrong here
A flat file lacks concurrent access controls, indexing, and distribution, so it cannot sustain high throughput across many servers. It is also prone to corruption when multiple users write at once. This option fails the scalability and performance requirements entirely, despite being simple to set up.
- ✗
A relational database using tables with fixed schemas and joins.
Why it's wrong here
Relational databases organize data into tables with a predefined schema and rely on joins, which can become a bottleneck when scaling horizontally across many nodes. While they can be distributed, their strength is strong consistency and structured queries, not simple high-throughput key-value access. This category does not best match the described requirement.
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.