AWS Certified Solutions Architect – ProfessionalDesign for New SolutionsHard

A software-as-a-service (SaaS) provider is building a new multi-tenant application where each tenant requires strong data isolation and dedicated resources. The application uses a relational database. To optimize costs and operational overhead, the provider wants to leverage serverless technologies as much as possible for the database layer. Which database strategy should be recommended?

  1. AA shared Amazon DynamoDB table with a tenant ID as a partition key.
  2. BA single Amazon Aurora Serverless v2 cluster with a separate schema for each tenant.
  3. CA dedicated Amazon RDS instance for each tenant.
  4. DMultiple Amazon Aurora Serverless v2 clusters, with one cluster per tenant.
Show answer & explanation

Correct answer: D. Multiple Amazon Aurora Serverless v2 clusters, with one cluster per tenant.

Dedicated Aurora Serverless v2 clusters per tenant provide strong data isolation and dedicated resources, meeting the requirements. Aurora Serverless v2 scales instantly and automatically, optimizing costs and operational overhead for variable tenant workloads while offering a relational database.

Why the other options are wrong

  • A. DynamoDB is a NoSQL database, and the requirement specifies a 'relational database'. While it offers isolation via partition keys, it does not meet the relational database type or the 'dedicated resources' for a relational model in a multi-tenant context.
  • B. A single Aurora Serverless v2 cluster with separate schemas provides logical isolation but not strong data isolation or dedicated compute resources per tenant, which is a key requirement.
  • C. Dedicated Amazon RDS instances provide strong isolation but incur higher operational overhead and fixed costs, which contradicts the goal of optimizing costs and leveraging serverless for the database layer.

Siloed Multi-Tenancy with Aurora Serverless v2

A multi-tenant architecture where each tenant receives a dedicated Amazon Aurora Serverless v2 cluster, providing strong data isolation, dedicated resources, and leveraging serverless benefits for relational databases.

  • Each tenant has a dedicated database instance/cluster.
  • Provides strongest data isolation and dedicated resources.
  • Aurora Serverless v2 offers auto-scaling and cost optimization for relational DBs.
  • Suitable for tenants with strict compliance or performance needs.

Memory trick: Each tenant gets their own Aurora Serverless v2 castle, perfectly isolated and auto-scaling.

More Design for New Solutions questions