mediumMultiple SelectObjective-mapped
FC0-U71 Practice Question: Which TWO of the following are advantages of…
Which TWO of the following are advantages of using a relational database management system (RDBMS) over a file-based system?
⚠ Common exam trap
A common mix-up: candidates assume 'faster data access' is always true for RDBMS due to indexing, but they overlook the overhead of SQL processing and the fact that file-based systems can be faster for simple, non-relational 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
✓
Enforcement of data integrity
A relational database management system (RDBMS) enforces data integrity through constraints such as primary keys, foreign keys, unique constraints, and check constraints. These rules ensure that data entered into the database adheres to defined business rules and referential integrity, preventing orphaned records and invalid data entries. In contrast, a file-based system relies on application code to enforce such rules, which is error-prone and inconsistent.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Enforcement of data integrity
Why this is correct
Constraints enforce accuracy and consistency.
- ✗
Faster data access for all queries
Why it's wrong here
Performance varies; indexed queries are fast, but not all.
- ✓
Reduced data redundancy
Why this is correct
Normalization reduces duplication.
- ✗
No need for a database administrator
Why it's wrong here
Most RDBMS environments require a DBA.
- ✗
Simpler setup and maintenance
Why it's wrong here
RDBMS requires explicit schema definition, normalisation, and index configuration—steps absent in file-based systems where data is simply stored in flat files. The temptation arises because file systems lack built-in referential integrity and concurrency management, so an RDBMS automates these safeguards; however, that automation imposes additional setup and maintenance tasks. For a single-user, static dataset with no relationships, a file-based system would indeed involve less administrative overhead.
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 →
Same concept, more angles
1 more way this is tested on FC0-U71
These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.
Variation 1. Which THREE of the following are types of data integrity enforced in relational databases?
medium- ✓ A.Referential integrity
- ✓ B.Entity integrity
- C.Network integrity
- D.File integrity
- ✓ E.Domain integrity
Why A: Entity integrity (via primary keys), referential integrity (via foreign keys), and domain integrity (via data types and constraints) are the three main types.
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.