Multiple choice technology architecture

A DBMS has a data cache hit ratio of 10%. What will you do to improve performance?

  1. Change the application code

  2. Do nothing

  3. Run every query twice

  4. Increase cache size significantly
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

A 10% cache hit ratio means 90% of data requests are cache misses, causing expensive disk I/O. Increasing cache size significantly allows more data to remain in memory, reducing disk accesses and improving performance. Changing application code or running queries twice would not address the fundamental cache sizing issue.

Keep practicing — related questions