For IndividualsFor Educators
ExpertMinds LogoExpertMinds
ExpertMinds

Ace your certifications with Practice Exams and AI assistance.

  • Browse Exams
  • For Educators
  • Blog
  • Privacy Policy
  • Terms of Service
  • Cookie Policy
  • Support
  • AWS SAA Exam Prep
  • PMI PMP Exam Prep
  • CPA Exam Prep
  • GCP PCA Exam Prep

© 2026 TinyHive Labs. Company number 16262776.

    PracticeAWS Solutions Architect Professional (SAP-C02)AWS Solutions Architect Professional SAP-C02 Practice Exam 1Question 28
    Medium1 markMultiple Choice
    Domain 3.3: Performance ImprovementPerformanceAuroraDatabase

    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:

    A.

    Migrate the database to Amazon Redshift.

    B.

    Implement Amazon ElastiCache for Redis in front of the database.

    C.

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

    D.

    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
    Create an Aurora Read Replica and route the analytical queries to the reader endpoint.
    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 27All questionsQuestion 29

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

    75 questions · hints · full answers · grading

    Sign up freeTake the exam

    More questions from this exam

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