nerdexam
CompTIA

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.

Database Fundamentals

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)
  • A
    93% (25)
  • B
    4% (1)
  • C
    4% (1)

Why each option

This question asks for the most suitable data storage solution when multiple users require concurrent access to the same data.

ADatabaseCorrect

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.

BSpreadsheet

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.

CText file

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.

DWord processing document

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

#database systems#concurrent access#data storage

Community Discussion

No community discussion yet for this question.

Full FC0-U61 Practice