FC0-U61 · Question #777
Which of the following would be the most effective use of a database?
The correct answer is D. To automate input of financial transactions and run daily reports. The most effective use of a database involves automating complex data operations like inputting financial transactions and generating reports, leveraging its capabilities for structured storage, integrity, and querying.
Question
Which of the following would be the most effective use of a database?
Options
- ATo keep a list of vendors to call daily
- BTo store visitor information at each location
- CTo list basic employee information for distribution
- DTo automate input of financial transactions and run daily reports
How the community answered
(33 responses)- A6% (2)
- B18% (6)
- C3% (1)
- D73% (24)
Why each option
The most effective use of a database involves automating complex data operations like inputting financial transactions and generating reports, leveraging its capabilities for structured storage, integrity, and querying.
Keeping a simple list of vendors to call daily is a basic task easily handled by a spreadsheet or text file, not requiring the full power of a database.
Storing visitor information can be done in a database, but if it lacks complex relationships, queries, or reporting, it might be overkill compared to simpler systems.
Listing basic employee information for distribution can be efficiently handled by a spreadsheet or a simple document, as it implies static data rather than dynamic operations and reporting.
Databases excel at managing large volumes of structured data, ensuring data integrity, and enabling complex queries and automation. Automating the input of financial transactions and running daily reports leverages these strengths, allowing for efficient data processing, analysis, and generation of insights.
Concept tested: Database purpose and appropriate use cases
Source: https://learn.microsoft.com/en-us/training/modules/relational-data-basics/2-what-is-database
Topics
Community Discussion
No community discussion yet for this question.