ExpertAWS 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)
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:
Migrate to Amazon Aurora PostgreSQL.
Use Aurora Serverless v2 to scale compute dynamically and Aurora database cloning to provision new tenants quickly.
Migrate to Amazon DynamoDB and use a separate table for each tenant.
Use Amazon RDS for PostgreSQL and provision a new DB instance from a snapshot for each new tenant.
Use Amazon Redshift and create a separate schema for each tenant.
Implement RDS Proxy to multiplex connections to the single shared database.
How to approach this question
Full Answer
Common mistakes
Practice the full AWS Solutions Architect Professional SAP-C02 Practice Exam 5
75 questions · hints · full answers · grading