FC0-U71 Data and Database Fundamentals Practice Question

Which of the following is a benefit of using a database instead of a flat file?

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

✓

Support for concurrent multi-user access

Databases provide concurrent access control, allowing multiple users to read/write data simultaneously without corruption.

Answer analysis

For each option: why learners choose it and why it is or isn't the right answer here.

✗
Simpler setup and configuration
Why it's wrong here
While a flat file might offer a more immediate and less involved initial setup for very basic data storage, databases introduce inherent complexity through their structured schema, query languages, and management overhead. This option is tempting because for trivial datasets or single-user applications where data integrity and complex relationships are not concerns, a flat file's direct accessibility can appear advantageous. However, this simplicity is precisely what databases overcome to provide robust data management.
✗
Faster file transfer speeds
Why it's wrong here
File transfer speed is not a typical database benefit.
✗
Lower storage requirements
Why it's wrong here
Databases may have overhead; flat files can be smaller.
✓
Support for concurrent multi-user access
Why this is correct
Correct. Databases handle concurrent access with locking and transactions.

Go deeper