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.
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)- A90% (27)
- B3% (1)
- D7% (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.
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.
Administering a database can be more complex than managing a simple spreadsheet, requiring specialized knowledge for tasks like backups, security, and performance tuning.
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.
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
Community Discussion
No community discussion yet for this question.