CV0-002 · Question #493
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
The correct answer is D. Migrate the database to DBaaS.. The on-premises database server is experiencing high memory and CPU utilization with no ability to scale up and a requirement for no capital expenditure. Migrating the database to a Database-as-a-Service (DBaaS) solution is the best option as it allows for elastic scaling and ope
Question
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?
Options
- AIncrease CPU on the database server.
- BAllocate more RAM to the database server.
- CIncrease storage on the database server.
- DMigrate the database to DBaaS.
- EMigrate the database to a new server.
How the community answered
(34 responses)- A9% (3)
- B15% (5)
- C3% (1)
- D68% (23)
- E6% (2)
Why each option
The on-premises database server is experiencing high memory and CPU utilization with no ability to scale up and a requirement for no capital expenditure. Migrating the database to a Database-as-a-Service (DBaaS) solution is the best option as it allows for elastic scaling and operates on an operational expenditure model.
Increasing CPU on the database server is a capital expenditure and contradicts the requirement for no capital expenditure, and the current on-premises infrastructure is already at capacity.
Allocating more RAM to the database server is a capital expenditure and contradicts the requirement for no capital expenditure, and the current on-premises infrastructure is already at capacity.
Increasing storage on the database server does not address high CPU and memory utilization and typically involves capital expenditure.
Migrating to a Database-as-a-Service (DBaaS) solution directly addresses resource exhaustion by providing elastic scaling capabilities for CPU and memory, eliminating the need for upfront hardware purchases. This approach shifts the expenditure from a capital expenditure (CapEx) model to an operational expenditure (OpEx) model, aligning with the requirement for no capital expenditure while resolving scalability issues.
Migrating the database to a new on-premises server would still incur capital expenditure for new hardware and would not provide the flexible, elastic scalability of a cloud service.
Concept tested: Cloud migration strategies and cost models for databases
Source: https://learn.microsoft.com/en-us/azure/architecture/guide/migrating-on-premises-databases
Topics
Community Discussion
No community discussion yet for this question.