Crucial Exams

AWS Certified Solutions Architect Professional SAP-C02 Practice Question

A retail company runs its e-commerce platform on an Amazon Aurora MySQL provisioned cluster with one writer and two readers. CloudWatch shows that the cluster's CPU utilization stays under 10 percent for most of the day but jumps to 80 percent for about 15 minutes when a flash-sale starts. The CTO asks you to modernize the database layer to cut costs and simplify capacity management while satisfying these requirements: (1) compute capacity must scale up or down within seconds without disrupting open connections or transactions, (2) the writer must remain highly available across multiple Availability Zones and fail over automatically, and (3) additional reader instances must be allowed to scale independently for read-heavy traffic. Which solution BEST meets the requirements with the least ongoing administration?

  • Convert the cluster to Amazon Aurora Serverless v2, define a minimum and maximum Aurora Capacity Unit range (for example 0.5-64 ACUs), enable Multi-AZ for the writer, and add Aurora Serverless v2 reader instances as needed.

  • Replace the Aurora cluster with Amazon DynamoDB in on-demand capacity mode and use AWS Database Migration Service for the initial data transfer.

  • Migrate the cluster to Amazon Aurora Serverless v1, enable automatic pause after 5 minutes of inactivity, and rely on its autoscaling to handle flash-sale traffic.

  • Keep the provisioned cluster, place Amazon RDS Proxy in front of it to pool connections, and configure Aurora Auto Scaling policies to add or remove provisioned read replicas based on CPU utilization.

AWS Certified Solutions Architect Professional SAP-C02
Accelerate Workload Migration and Modernization
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot