CV0-002 · Question #566
A company is planning to support a new branch office with increased application workload compared to the existing branch's cloud deployments. The engineer has provided the junior engineer and…
The correct answer is D. Add a vCPU to the database server, keeping the same RAM and storage resource specifications. To support a new branch office with increased application workload, the best recommendation is to add a vCPU to the database server, as database operations are often a bottleneck under higher loads.
Question
A company is planning to support a new branch office with increased application workload compared to the existing branch's cloud deployments. The engineer has provided the junior engineer and systems administrator with a standard deployment plan to analyze the new branch requirements. Given the existing branch office requirements and the deployment plan above, which of the following should the junior engineer or systems administrator recommend to BEST size the deployment to meet the new branch office requirements?
Exhibit
Options
- AAdd RAM to the database server, keeping the same vCPU and storage resource specifications.
- BAdd RAM to the web server, keeping the same vCPU and storage resource specifications.
- CAdd a vCPU to each fileshare server, keeping the same RAM and storage resource
- DAdd a vCPU to the database server, keeping the same RAM and storage resource specifications.
How the community answered
(17 responses)- A29% (5)
- B12% (2)
- C6% (1)
- D53% (9)
Why each option
To support a new branch office with increased application workload, the best recommendation is to add a vCPU to the database server, as database operations are often a bottleneck under higher loads.
Adding RAM to the database server might help if the database is memory-bound, but for increased application workload, CPU is typically the first bottleneck for query execution.
Adding RAM to the web server primarily helps with concurrent connections or caching on the web layer, but the 'increased application workload' often points to backend processing, making the database a more likely bottleneck.
Adding a vCPU to each fileshare server is unlikely to be the primary solution for 'increased application workload' as fileshare servers are typically I/O or network bound, not CPU bound, for typical branch office applications.
Increased application workload typically translates to more requests and data processing, which frequently places a heavy load on the database server. Databases are often CPU-bound, meaning they require significant processing power to handle queries, transactions, and data manipulation. Adding a vCPU directly enhances the database server's ability to process these concurrent workloads, thereby improving overall application performance and responsiveness.
Concept tested: Application workload sizing - database scaling
Topics
Community Discussion
No community discussion yet for this question.
