CompTIA DataSys+ (DS0-001)Database DeploymentMedium
A database administrator is planning the deployment of a new database server for an application that will experience highly variable workloads, with peak demands occurring unpredictably. The administrator wants to ensure that the database can automatically scale its compute and storage resources up and down based on demand, without manual intervention. Which database deployment model would best meet these requirements?
- AContainerized database on a Kubernetes cluster with fixed resource limits.
- BOn-premises dedicated server with manual scaling.
- CVirtual machine in a private cloud with pre-allocated resources.
- DServerless database in a public cloud.
Show answer & explanationAnswer & explanation
Correct answer: D. Serverless database in a public cloud.
A serverless database automatically scales its compute and storage resources up and down based on actual demand, charging only for what is consumed. This perfectly matches the requirement for automatic, hands-off scaling for highly variable and unpredictable workloads.
Why the other options are wrong
- A. Fixed resource limits in Kubernetes prevent automatic scaling beyond those limits without manual adjustments.
- B. Manual scaling requires intervention and cannot respond automatically to variable workloads.
- C. Pre-allocated resources do not automatically scale and can lead to over-provisioning or under-provisioning.
Serverless Database
A serverless database is a cloud-native database service that automatically scales its compute and storage capacity based on demand, eliminating the need for database administrators to provision, patch, or manage servers.
- Automatic scaling of compute and storage.
- Pay-per-use pricing model (only for consumption).
- No server management required.
- Ideal for unpredictable and bursty workloads.
Memory trick: Serverless is like a smart thermostat for your database – it adjusts itself perfectly.