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.
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)- A8% (2)
- B88% (22)
- D4% (1)
Why each option
Databases inherently provide robust support for multiple users to concurrently access and modify data without integrity issues, unlike flat files.
Flat files can often be more portable as they are simpler text files, while databases often require specific software to be read or managed.
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.
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.
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
Community Discussion
No community discussion yet for this question.