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 5Question 32
    Hard1 markMultiple Choice
    Domain 2.5: PerformanceDatabaseAuroraSaaSArchitecture

    AWS SAP-C02 · Question 32 · Domain 2.5: Performance

    A global SaaS provider is re-architecting their multi-tenant application. Currently, all tenants share a single Amazon RDS for PostgreSQL database, leading to 'noisy neighbor' performance issues and complex data isolation. The business wants to move to a siloed tenant model where each tenant has their own database. They need to provision new tenant databases in seconds, scale compute independently of storage, and minimize storage costs for tenants with sparse data. Which combination of services and features should be used? (Select TWO)

    Answer options:

    A.

    Migrate to Amazon Aurora PostgreSQL.

    B.

    Use Aurora Serverless v2 to scale compute dynamically and Aurora database cloning to provision new tenants quickly.

    C.

    Migrate to Amazon DynamoDB and use a separate table for each tenant.

    D.

    Use Amazon RDS for PostgreSQL and provision a new DB instance from a snapshot for each new tenant.

    E.

    Use Amazon Redshift and create a separate schema for each tenant.

    F.

    Implement RDS Proxy to multiplex connections to the single shared database.

    How to approach this question

    Look for the Aurora features that allow instant provisioning (cloning) and dynamic scaling (Serverless v2).

    Full Answer

    Amazon Aurora separates compute and storage. Aurora Serverless v2 scales compute instantly, ensuring tenants only pay for what they use and are isolated from noisy neighbors. Aurora Database Cloning allows you to create a new cluster from an existing one in seconds. It uses a copy-on-write protocol, meaning the clone shares the storage of the original until changes are made, saving significant storage costs.

    Common mistakes

    Choosing RDS snapshots, which are too slow for instant provisioning.
    Question 31All questionsQuestion 33

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

    75 questions · hints · full answers · grading

    Sign up freeTake the exam

    More questions from this exam

    Q01A global enterprise is redesigning its AWS network architecture across 50 AWS accounts and 3 AWS ...HardQ02A company uses AWS Organizations to manage multiple accounts. The security team mandates that no ...MediumQ03A financial institution requires a disaster recovery strategy for its critical trading applicatio...HardQ04An enterprise is setting up a new multi-account AWS environment using AWS Control Tower. They nee...MediumQ05A company has a complex AWS environment with hundreds of linked accounts under AWS Organizations....Hard
    View all 75 questions →