Continuous Improvement for Existing Solutions III
Prepare yourself for the AWS Certified Solutions Architect Professional (SAP-C02) exam with advanced questions on Aurora performance tuning, serverless database scaling, global traffic routing, edge caching, and cost-efficient Athena data lake optimization.
We'll cover the following...
Question 52
An Aurora PostgreSQL-backed checkout application has been experiencing rising latency after a new promotion feature was released. EC2 CPU and database CPU are moderate. RDS Performance Insights shows high Average Active Sessions dominated by lock wait events and a few top SQL statements. Which action should a solutions architect recommend?
A. Add Amazon DynamoDB Accelerator (DAX) and more application servers to increase request throughput.
B. Scale the Aurora writer to the largest available instance class because moderate CPU indicates hidden compute starvation.
C. Add Aurora read replicas and route checkout write transactions to the replicas to remove contention from the writer.
D. Use Performance Insights and PostgreSQL query logs to identify contending transactions, shorten transaction scope, add or adjust indexes, tune the SQL statements, and deploy the fix through a safe rollout.
Question 53
A serverless API ...