AWS SAP-C02 · Question 28 · Domain 3.3: Performance Improvement
A database administrator notices that an Amazon Aurora PostgreSQL database is experiencing high CPU utilization during complex analytical queries. These queries are impacting the performance of the primary transactional application. How can the architect improve performance with minimal application changes?
Answer options:
Migrate the database to Amazon Redshift.
Implement Amazon ElastiCache for Redis in front of the database.
Create an Aurora Read Replica and route the analytical queries to the reader endpoint.
Enable Aurora Serverless v2 scaling.
75 questions · hints · full answers · grading