FC0-U61 · Question #888
Multiple users need to access the same data simultaneously. Which of the following is the best place to store the data?
The correct answer is A. Database. This question asks for the most suitable data storage solution when multiple users require concurrent access to the same data.
Question
Multiple users need to access the same data simultaneously. Which of the following is the best place to store the data?
Options
- ADatabase
- BSpreadsheet
- CText file
- DWord processing document
How the community answered
(27 responses)- A93% (25)
- B4% (1)
- C4% (1)
Why each option
This question asks for the most suitable data storage solution when multiple users require concurrent access to the same data.
A database management system (DBMS) is specifically designed to handle concurrent access from multiple users, providing mechanisms for data integrity, locking, and transaction management to prevent conflicts and ensure consistent data. It allows multiple users to read and write data simultaneously without corrupting the dataset.
While spreadsheets can be shared, they are generally not optimized for simultaneous write access by multiple users and can easily lead to data corruption or version control issues.
Text files are not designed for concurrent multi-user access and typically lack any mechanisms for data integrity or conflict resolution when multiple users attempt to modify them.
Word processing documents are primarily for single-user editing and lack robust features for concurrent multi-user access and data integrity.
Concept tested: Data storage solutions - concurrency
Source: https://learn.microsoft.com/en-us/sql/sql-server/sql-server-database-engine
Topics
Community Discussion
No community discussion yet for this question.