nerdexam
CompTIA

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.

Database Fundamentals

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)
  • A
    6% (2)
  • B
    18% (6)
  • C
    3% (1)
  • D
    73% (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.

ATo keep a list of vendors to call daily

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.

BTo store visitor information at each location

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.

CTo list basic employee information for distribution

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.

DTo automate input of financial transactions and run daily reportsCorrect

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

#database applications#transaction processing#reporting#data management

Community Discussion

No community discussion yet for this question.

Full FC0-U61 Practice