nerdexam
CompTIA

CV0-003 · Question #742

A cloud administrator is monitoring a database system and notices an unusual increase in the read operations, which is causing a heavy load in the system. The system is using a relational database and

The correct answer is B. Use a cache system to store reading operations. A cache system is a temporary storage that stores frequently accessed data. This can help to improve the performance of the database system by reducing the number of times the database needs to be accessed.

Operations

Question

A cloud administrator is monitoring a database system and notices an unusual increase in the read operations, which is causing a heavy load in the system. The system is using a relational database and is running in a VM. Which of the following should the administrator do to resolve the issue with minimal architectural changes?

Options

  • AMigrate the relational database to a NoSQL database
  • BUse a cache system to store reading operations
  • CCreate a secondary standby database instance
  • DImplement the database system using a DBaaS

How the community answered

(36 responses)
  • A
    8% (3)
  • B
    75% (27)
  • C
    14% (5)
  • D
    3% (1)

Explanation

A cache system is a temporary storage that stores frequently accessed data. This can help to improve the performance of the database system by reducing the number of times the database needs to be accessed.

Topics

#caching#database performance#read optimization#relational database

Community Discussion

No community discussion yet for this question.

Full CV0-003 Practice