nerdexam
CompTIA

FC0-U71 · Question #146

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

The correct answer is B. Multiple concurrent users. Databases inherently provide robust support for multiple users to concurrently access and modify data without integrity issues, unlike flat files.

Data and Database Fundamentals

Question

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

Options

  • APortability
  • BMultiple concurrent users
  • CCloud support
  • DSpeed to implement

How the community answered

(25 responses)
  • A
    8% (2)
  • B
    88% (22)
  • D
    4% (1)

Why each option

Databases inherently provide robust support for multiple users to concurrently access and modify data without integrity issues, unlike flat files.

APortability

Flat files can often be more portable as they are simpler text files, while databases often require specific software to be read or managed.

BMultiple concurrent usersCorrect

Databases are designed with concurrency control mechanisms to handle multiple users accessing and modifying data simultaneously without data corruption. Flat files typically struggle with concurrent access, often leading to data integrity issues or requiring manual locking.

CCloud support

While many modern databases offer cloud support, flat files can also be stored and accessed in the cloud, so it's not a unique advantage of databases over flat files.

DSpeed to implement

Flat files are generally much quicker to implement for simple data storage scenarios compared to setting up a relational database, which requires schema definition and potentially more complex configuration.

Concept tested: Database vs. flat file concurrency

Source: https://learn.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview

Topics

#Database fundamentals#Flat files#Concurrency control#Data storage

Community Discussion

No community discussion yet for this question.

Full FC0-U71 Practice