CompTIA DataSys+ (DS0-001)Database DeploymentHard
A database administrator is planning to deploy a new database server for a web application that will experience unpredictable and spiky traffic patterns. The application needs to scale quickly and automatically to handle sudden increases in load without manual intervention. Which cloud database deployment model would be most appropriate?
- ASelf-managed database on IaaS VMs
- BServerless database
- COn-premises database cluster
- DManaged database service with fixed instance size
Show answer & explanationAnswer & explanation
Correct answer: B. Serverless database
Serverless databases (like AWS Aurora Serverless, Azure SQL Database Serverless) are designed to automatically scale computing and storage resources up and down based on demand, handling unpredictable and spiky traffic patterns without manual intervention or pre-provisioning, and billing only for actual consumption.
Why the other options are wrong
- A. Self-managed databases on IaaS require manual scaling and management, which doesn't meet the 'scale quickly and automatically' requirement.
- C. On-premises databases require significant manual effort for scaling and cannot respond quickly to unpredictable spikes without over-provisioning.
- D. A managed database service with a fixed instance size still requires manual intervention to scale up or down, or might incur high costs for over-provisioning.
Serverless Database
A cloud database deployment model where the database automatically scales its compute and storage resources up or down based on demand, and users are billed only for actual usage.
- Automatic scaling of compute and storage.
- Pay-per-use billing model.
- Ideal for unpredictable and spiky workloads.
- Reduces operational overhead for database administrators.
Memory trick: Scaling in the cloud: how much control, how much auto?