Which of the following offers a DBA the ability to gather important performance metrics to help optimize SQL queries and parameters for a database instance?

Question

Options

• ADatabase recovery
• BDatabase monitoring
• CDatabase security
• DDatabase maintenance

• A
  2% (1)
• B
  92% (49)
• C
  2% (1)
• D
  4% (2)

Explanation

Database monitoring is correct because it is the practice of continuously observing a database system's behavior, collecting metrics like query execution times, index usage, lock contention, and resource consumption - all of which a DBA uses to identify bottlenecks and tune SQL queries and configuration parameters.

Database recovery (A) focuses on restoring data after failure or corruption, not on gathering performance data. Database security (C) deals with access control, authentication, and protecting data from unauthorized use - performance optimization is outside its scope. Database maintenance (D) covers routine tasks like index rebuilding, statistics updates, and purging old data, but it is a reaction to performance issues, not the act of gathering metrics to diagnose them.

Memory tip: Think of monitoring as a doctor taking your vitals - it measures how the system is performing so you know what to fix. Recovery, security, and maintenance are treatments or protections, not measurements.

No community discussion yet for this question.