nerdexam
CompTIA

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

Cloud architecture

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)
  • A
    9% (3)
  • B
    15% (5)
  • C
    3% (1)
  • D
    68% (23)
  • E
    6% (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.

AIncrease CPU on the database server.

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.

BAllocate more RAM to the database server.

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.

CIncrease storage on the database server.

Increasing storage on the database server does not address high CPU and memory utilization and typically involves capital expenditure.

DMigrate the database to DBaaS.Correct

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.

EMigrate the database to a new server.

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

#On-premises scaling#Capital expenditure#DBaaS migration#Cloud adoption strategy

Community Discussion

No community discussion yet for this question.

Full CV0-002 Practice