CompTIA DataSys+ (DS0-001)Database DeploymentMedium
A database administrator is planning the deployment of a new database server for an application that will experience peak loads during specific business hours, requiring a significant increase in CPU and memory resources. Outside of these hours, resource utilization is low. Which cloud deployment model would be MOST cost-effective while ensuring performance during peak times?
- ACloud instance with reserved capacity
- BOn-premises dedicated server
- CCloud instance with on-demand scaling
- DServerless database
Show answer & explanationAnswer & explanation
Correct answer: C. Cloud instance with on-demand scaling
A cloud instance with on-demand scaling allows the database to automatically provision or de-provision resources (CPU, memory) based on actual demand, making it highly cost-effective for fluctuating workloads by paying only for what is used.
Why the other options are wrong
- A. Reserved capacity involves committing to a certain level of resources, which might be cheaper than on-demand for consistent high usage, but less cost-effective for highly fluctuating, intermittent peaks.
- B. An on-premises dedicated server would require provisioning for peak load, leading to high idle costs during off-peak hours.
- D. Serverless databases are ideal for unpredictable, spiky workloads with long idle periods, but for predictable 'peak loads during specific business hours', on-demand scaling of a dedicated instance might offer more control and predictable performance.
Cloud Database Scaling
The ability of a cloud database to adjust its resources (CPU, memory, storage) dynamically to meet changing workload demands.
- Vertical scaling: increasing resources of a single instance.
- Horizontal scaling: adding more instances to distribute load.
- On-demand scaling: resources adjust automatically based on real-time usage.
- Cost-effective for variable workloads by paying only for consumed resources.
Memory trick: Scale up and down, save your crown.