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.

How to approach this question

Identify the pattern for separating read-heavy workloads from write-heavy workloads in Aurora.

Full Answer

C.Create an Aurora Read Replica and route the analytical queries to the reader endpoint.✓ Correct

Aurora Read Replicas allow you to scale out read operations. By directing analytical queries to the reader endpoint, the primary instance's CPU is freed up for transactional writes.

Common mistakes

Choosing ElastiCache, which is not suitable for complex analytical queries.

Question 27 All questions Question 29

Practice the full AWS Solutions Architect Professional SAP-C02 Practice Exam 1

75 questions · hints · full answers · grading

More questions from this exam

Q01An enterprise has 50 VPCs across two AWS Regions. They need to establish transitive routing betwe...Hard Q02A company uses AWS Organizations. The security team wants to ensure that no IAM user or role can ...Medium Q03An application requires a relational database with an RPO of 1 second and an RTO of less than 1 m...Hard Q04A company is setting up a new multi-account environment. They want to automate the provisioning o...Medium Q05An organization wants to allocate AWS costs to specific business units. They use AWS Organization...Hard

View all 75 questions →