Machine-translated by Google. Questions are authored in English.
Top

Discussion

Performance analysis and tuning is which of the following?

  • A.Undertaken one time at the time of a DBMS installation
  • B.Undertaken one time at the time of the implementation of a new application
  • C.Undertaken as an ongoing part of the backup of a database
  • D.Undertaken as an ongoing part of managing a database

Answer: D

Correct answer: Undertaken as an ongoing part of managing a database

Performance tuning is continuous, not a one-off at installation. Data volumes grow, the mix of queries changes, indexes that once helped become a burden on updates - so a database that was well tuned last year may not be now. Monitoring and adjustment are part of ordinary administration.

No comment is present. Be the first to comment.
Loading…

Post your comment

Please log in or register to post a comment.