nerdexam
CompTIA

CV0-002 · Question #279

After deploying multiple copies of database servers, data scrambling is started on them to anonymize user data. A few minutes later, the systems administrator receives multiple complaints regarding…

The correct answer is B. Database drivers. After eliminating CPU and memory as bottlenecks when other VMs experience performance issues following database data scrambling, the next step should be to verify database drivers.

Troubleshooting

Question

After deploying multiple copies of database servers, data scrambling is started on them to anonymize user data. A few minutes later, the systems administrator receives multiple complaints regarding the performance of other VMs. CPU and memory have been eliminated as possible bottlenecks. Which of the following should be verified NEXT as a possible bottleneck?

Options

  • AStorage array
  • BDatabase drivers
  • CHardware load balancer
  • DInternet connection speed

How the community answered

(56 responses)
  • A
    30% (17)
  • B
    45% (25)
  • C
    16% (9)
  • D
    9% (5)

Why each option

After eliminating CPU and memory as bottlenecks when other VMs experience performance issues following database data scrambling, the next step should be to verify database drivers.

AStorage array

While storage array contention is a common issue with I/O-intensive database operations, verifying database drivers first helps identify if the cause of excessive storage I/O is an application-layer inefficiency, rather than solely a storage array capacity issue.

BDatabase driversCorrect

Inefficient or faulty database drivers can cause excessive I/O operations, internal locking contention, or poor resource utilization within the database servers, leading to degraded database performance that impacts other client VMs even if CPU and memory on the database servers are not maxed out. The scrambling operation puts a specific load on the database layer where drivers play a critical role.

CHardware load balancer

A hardware load balancer typically distributes network traffic and would primarily cause issues related to network availability or uneven distribution, which is less directly tied to an internal "data scrambling" process impacting other VMs unless the database servers themselves are failing.

DInternet connection speed

Internet connection speed is generally external to the internal VM-to-VM communication within a datacenter or cloud, and thus less likely to be the primary bottleneck for internal VM performance issues following an internal database operation.

Concept tested: Troubleshooting database performance in virtualized environments

Source: https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/performance/diagnose-resolve-latch-contention-sql-server

Topics

#performance bottleneck#database performance#troubleshooting#resource contention

Community Discussion

No community discussion yet for this question.

Full CV0-002 Practice