CompTIACompTIA
FC0-U71 · Question #149
FC0-U71 Question #149: Real Exam Question with Answer & Explanation
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
Explanation
Converting a large spreadsheet to a database is best done to support a large number of concurrent users, which spreadsheets handle poorly.
Common mistakes.
- B. Administering a database can be more complex than managing a simple spreadsheet, requiring specialized knowledge for tasks like backups, security, and performance tuning.
- C. 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.
- D. 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)
Reference. 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.