ExpertMinds LogoExpertMinds
Medium1 markMultiple Choice
Domain 3.3: Performance ImprovementPerformanceAuroraDatabase

AWS SAP-C02 · Question 13 · Domain 3.3: Performance Improvement

A company is running a high-traffic e-commerce website on AWS. The database tier uses Amazon Aurora MySQL. During flash sales, the database experiences high CPU utilization due to a massive volume of read queries for product catalogs, causing latency. What is the MOST cost-effective way to improve performance without changing the application code?

Answer options:

A.

Migrate the product catalog data to Amazon DynamoDB.

B.

Implement Amazon ElastiCache for Redis in front of the database.

C.

Add Aurora Replicas and configure the application's database driver to use the Aurora Reader Endpoint.

D.

Scale up the Aurora primary instance to the largest available instance class.

How to approach this question

Identify the solution that scales read capacity with minimal code changes.

Full Answer

C.Add Aurora Replicas and configure the application's database driver to use the Aurora Reader Endpoint.✓ Correct
Add Aurora Replicas and configure the application's database driver to use the Aurora Reader Endpoint.
Aurora Replicas allow you to scale read operations. The Reader Endpoint automatically load-balances connections across all available replicas, requiring minimal configuration changes.

Common mistakes

Choosing ElastiCache, which requires rewriting application logic to check the cache.
12All questions14

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

75 questions · hints · full answers · grading

Sign up freeTake the exam

More questions from this exam

Q01A global enterprise is designing a multi-region network architecture connecting 50 AWS accounts a...HardQ02A company is migrating its hybrid network to AWS. They have two 10 Gbps AWS Direct Connect connec...HardQ03An enterprise has 100 AWS accounts in AWS Organizations. The security team mandates that all Amaz...MediumQ04A financial company requires that all EBS volumes, S3 buckets, and RDS databases be encrypted usi...EasyQ05An enterprise is designing a disaster recovery strategy for a critical application running on Ama...Hard
View all 75 questions →