The On-Premises Database Server Is Experiencing High Memory and CPU

question 226

Multiple Choice

The on-premises database server is experiencing high memory and CPU utilization over the course of a month. The current on-premises infrastructure is at capacity with no ability to scale up. The Chief Technology Officer (CTO) has asked the CSA to provide a solution without any capital expenditure. Which of the following is the BEST solution to resolve the issue?

• A) Increase CPU on the database server.
• B) Allocate more RAM to the database server.
• C) Increase storage on the database server.
• D) Migrate the database to DBaaS.
• E) Migrate the database to a new server.

---

Definitions:

Mantle-Derived Magmas

Magma that originates from the melting of the Earth's mantle, leading to volcanic activity.

Continental Crust

The layer of igneous, sedimentary, and metamorphic rocks that forms the continents and continental shelves, characterized by its thickness and composition distinct from oceanic crust.

Mafic Basalt

A type of basaltic rock that is rich in magnesium and iron, characterized by its dark color and low silica content.

Decompression Melting

The melting of rock due to a decrease in pressure as it rises towards the Earth's surface, a common mechanism at mid-ocean ridges and mantle plumes.