CV0-003 · 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. With CPU and memory already eliminated, the database drivers are the next component to verify because they mediate all data access during the scrambling process and can generate excessive I/O and contention that degrades other VMs sharing the environment.
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
(63 responses)- A6% (4)
- B84% (53)
- C2% (1)
- D8% (5)
Why each option
With CPU and memory already eliminated, the database drivers are the next component to verify because they mediate all data access during the scrambling process and can generate excessive I/O and contention that degrades other VMs sharing the environment.
The storage array is a reasonable concern for I/O-heavy workloads, but it should be investigated after the database driver layer - which sits between the application and storage - has been ruled out as the source of excessive requests.
Data scrambling workloads use database drivers to read, transform, and write large volumes of records, and misconfigured or inefficient drivers can produce excessive I/O requests, connection pool exhaustion, or aggressive locking that saturates shared infrastructure. Since CPU and memory are ruled out, the software layer between the application and storage - the database drivers - is the next logical bottleneck to inspect. Driver-level inefficiencies can create resource contention that cascades to other VMs on the same host or storage fabric.
A hardware load balancer distributes external network traffic and is not involved in the internal communication between data scrambling processes and the database servers.
Internet connection speed affects external-facing traffic only and is unrelated to the performance of internal VMs communicating with database servers on the local network.
Concept tested: Identifying database driver bottlenecks during heavy workloads
Source: https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/performance/troubleshoot-sql-io-performance
Topics
Community Discussion
No community discussion yet for this question.