What should a database specialist do to meet these requirements?
Use reserved capacity. Set it to the capacity levels required for peak daytime throughput.
Use provisioned capacity. Set it to the capacity levels required for peak daytime throughput.
Use provisioned capacity. Create an AWS Application Auto Scaling policy to update capacity based on consumption.
Use on-demand capacity.
Explanations:
Reserved capacity provides a discount on long-term usage but requires estimating peak requirements. This option is not ideal for handling fluctuating traffic as seen in daily peak-hour surges.
Provisioned capacity set for peak throughput could prevent throttling but would lead to high costs during off-peak hours, as unused capacity would still incur charges.
Provisioned capacity with AWS Application Auto Scaling allows scaling up and down based on demand, reducing throttling during peak times and lowering costs during low-traffic periods.
On-demand capacity can handle variable traffic, but it is more costly over time compared to provisioned capacity with scaling, especially for predictable daily traffic patterns.