Q82 — AWS SAA-C03 Ch.13

Question 82 of 100 | ← Chapter 13

Q982. A company uses an Amazon Aurora PostgreSQL provisioned cluster with its application. The application's peak traffic occurs several times a day for periods of 30 minutes to several hours.The database capacity is provisioned to handle peak traffic from the application,but the database has wasted capacity during hon-peak hours. The company wants to reduce the database costs.Which solution will meet these requirements with the LEAST operational effort?

• A. Set up an Amazon CloudWatch alarm to monitor database utilization. Scale up or scale down the database capacity based on the amount of traffic.
• B. Migrate the database to Amazon EC2 instances in an Auto Scaling group. Increase or decrease the number of instances based on the amount of traffic.
• C. Migrate the database to an Amazon Aurora Serverless DB cluster to scale up or scale down the capacity based on the amount of traffic. ✓
• D. Schedule an AWS Lambda function to provision the required database capacity at the start of each day.Schedule another Lambda function to reduce the capacity at the end of each day.

Correct Answer: C. Migrate the database to an Amazon Aurora Serverless DB cluster to scale up or scale down the capacity based on the amount of traffic.

Explanation

The correct answer is:C. Migrate the database to an Amazon Aurora Serverless DB cluster to scale up or scale down the capacity based on the amount of traffic.Explanation:A. Set up an Amazon CloudWatch alarm to monitor database utilization. Scale up or scale down the database capacity based on the amount of traffic.- This solution would require manual intervention to scale the database capacity up and down, which can be time-consuming and may not be able to keep up with rapid changes in traffic patterns.B. Migrate the database to Amazon EC2 instances in an Auto Scaling group. Increase or decrease the number of instances based on the amount of traffic.- This solution would require more operational effort compared to the Aurora Serverless option, as you would need to manage the EC2 instances, the Auto Scaling group, and the database software deployment.C. Migrate the database to an Amazon Aurora Serverless DB cluster to scale up or scale down the capacity based on the amount of traffic.- This is the best solution with the least operational effort.- Amazon Aurora Serverless automatically scales the database capacity up and down based on the application's needs, without the need for manual intervention.- This feature can help reduce the database costs by provisioning only the required capacity during non- peak hours, and scaling up during peak traffic periods.- The migration to an Aurora Serverless DB cluster would also be easier compared to setting up and managing an EC2-based database solution.D. Schedule an AWS Lambda function to provision the required database capacity at the start of each day. Schedule another Lambda function to reduce the capacity at the end of each day.- This solution would require more operational effort compared to the Aurora Serverless option, as you would need to manage the scheduled Lambda functions and ensure they are correctly scaling the database capacity.- It may also not be able to respond to unexpected changes in traffic patterns during the day.Therefore, the best solution with the least operational effort is to migrate the database to an Amazon Aurora Serverless DB cluster.