AWS Certified Solutions Architect Professional SAP-C02 Practice Question

An advertising-technology company runs latency-sensitive bidding services in Amazon ECS Fargate spread across two Availability Zones behind an Application Load Balancer. Every service issues identical read-only SQL queries to a Multi-AZ Amazon RDS for PostgreSQL primary DB instance. To offload connections, the team added two RDS read replicas and enabled Amazon RDS Proxy, yet during peak traffic the database CPU still reaches 90 % and the 95th-percentile (p95) GET latency at the API endpoint rises from 4 ms to 15 ms. Each extra millisecond of latency reduces revenue. The engineering team must push p95 latency below 5 ms and reduce database load without a major code rewrite or managing additional EC2 instances.

Which solution will most effectively meet the performance objective?

  • Provision an Amazon ElastiCache for Redis cluster in cluster mode and modify the microservices to cache query results with a short TTL, falling back to RDS on a cache miss.

  • Place an Amazon CloudFront distribution in front of the ALB and configure a 60-second cache TTL for all /api/* paths.

  • Migrate to Amazon Aurora PostgreSQL, enable parallel query, and add additional Aurora Replicas across multiple Availability Zones.

  • Scale the primary RDS instance up to a db.r6g.16xlarge and add 100 000 Provisioned IOPS storage.

AWS Certified Solutions Architect Professional SAP-C02
Design for New Solutions
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.

Bash, the Crucial Exams Chat Bot
AI Bot