nerdexam
CompTIA

FC0-U71 · Question #149

An administrator wants to convert a large spreadsheet to a database. Which of the following is the best reason for doing so?

The correct answer is A. Number of concurrent users. Converting a large spreadsheet to a database is best done to support a large number of concurrent users, which spreadsheets handle poorly.

Data and Database Fundamentals

Question

An administrator wants to convert a large spreadsheet to a database. Which of the following is the best reason for doing so?

Options

  • ANumber of concurrent users
  • BEase of administration
  • CFewer computer resources
  • DAccess speed

How the community answered

(30 responses)
  • A
    90% (27)
  • B
    3% (1)
  • D
    7% (2)

Why each option

Converting a large spreadsheet to a database is best done to support a large number of concurrent users, which spreadsheets handle poorly.

ANumber of concurrent usersCorrect

Spreadsheets are generally not designed for robust multi-user access and can suffer from data integrity issues or locking problems when many users try to access or modify them simultaneously. Databases excel at managing concurrency, ensuring data consistency and preventing conflicts among multiple users.

BEase of administration

Administering a database can be more complex than managing a simple spreadsheet, requiring specialized knowledge for tasks like backups, security, and performance tuning.

CFewer computer resources

Databases, especially relational ones, often require more computer resources (CPU, RAM, storage) to run their server processes and manage complex data structures compared to a simple spreadsheet file.

DAccess speed

While databases can offer optimized query performance, for simple data retrieval from a flat spreadsheet, the spreadsheet might be faster or comparable; the primary advantage is not always raw access speed for all operations.

Concept tested: Spreadsheet vs. database advantages (concurrency)

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

Topics

#Database fundamentals#Spreadsheet vs. Database#Concurrent access#Data management

Community Discussion

No community discussion yet for this question.

Full FC0-U71 Practice