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?
Place an Amazon CloudFront distribution in front of the ALB and configure a 60-second cache TTL for all /api/* paths.
Scale the primary RDS instance up to a db.r6g.16xlarge and add 100 000 Provisioned IOPS storage.
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.
Migrate to Amazon Aurora PostgreSQL, enable parallel query, and add additional Aurora Replicas across multiple Availability Zones.
Caching the hot, read-only query results in an in-memory data store eliminates most round-trips to disk-based storage and delivers microsecond response times. Amazon ElastiCache for Redis natively provides sub-millisecond latency and can serve millions of requests per second, so placing a short-TTL cache in front of the database immediately cuts CPU utilization and meets the < 5 ms p95 requirement with only minor code changes.
Simply scaling the RDS instance (larger class and more IOPS) improves throughput but still involves disk I/O and network hops that rarely reach micro-second latency. Migrating to Aurora and enabling parallel query benefits analytical scans, not small OLTP reads, and read replicas still introduce replica-lag risk. Deploying CloudFront in front of the ALB targets Internet edge-to-origin latency-not the service-to-database path-and cannot cache dynamic API responses reliably, so it does not address the primary performance bottleneck.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is Amazon ElastiCache for Redis?
Open an interactive chat with Bash
Why does caching with a short TTL improve database performance?
Open an interactive chat with Bash
How does Amazon RDS Proxy work, and why does it alone not solve high CPU utilization?
Open an interactive chat with Bash
AWS Certified Solutions Architect Professional SAP-C02
Design for New Solutions
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .