SAP-C02 Practice Question 84: Aurora Serverless v2 Tenant Clusters

AWS Certified Solutions Architect – Professional (SAP-C02) · Test 9 · question 4 of 10

Design for New Solutionsmedium

A SaaS company gives each of its 300 business customers a separate, isolated PostgreSQL-compatible database for compliance reasons. Each tenant is busy for a few hours at different times of day, is nearly idle otherwise, and occasionally has sudden spikes during promotions. Sizing one provisioned database instance per tenant for its peak is too expensive, but the company must keep the per-tenant isolation and the ability to use features such as cloning and snapshot restore for individual tenants.

Which solution meets these requirements MOST cost-effectively?

Show answer and explanation

Answer:

D. Create one Aurora Serverless v2 cluster per tenant, with a low minimum and a high maximum capacity

Aurora Serverless is described as *"especially valuable for multitenant databases ... and other environments with highly variable and unpredictable workloads."* AWS explains the multi-tenant pattern directly: *"You can create a cluster for each tenant. That way, you can use features such as cloning, snapshot restore, and Aurora global databases ... Each cluster can have a wide capacity range. That way, clusters with low activity incur minimal DB instance charges. Any cluster can quickly scale up to handle periods of high activity."* Scaling happens in increments as small as 0.5 ACU without disrupting connections, and usage is billed per second (option D).

- A is wrong because separating tenants by schema in one cluster does not give the per-tenant isolation and per-tenant clone or restore that the company requires, and a noisy tenant affects the others. - B is wrong because 300 provisioned clusters sized for peak pay for idle capacity around the clock, which is the cost problem the company wants to solve. - C is wrong because burstable instances have fixed CPU credit limits, so a promotional spike can exhaust the credits and throttle a tenant, and they do not scale capacity on demand.

Reference: Using Aurora serverless

Practice Test 9 ›

Study guides for SAP-C02

Which AWS certification should you get? 2026 roadmapWhich AWS certification to get first, by role and experience, with each exam's status in October 2026, what is changing, and prices in USD and INR.

SAP-C02 vs SAP-C03, the Solutions Architect Professional updateWhat changes when AWS replaces SAP-C02 with SAP-C03, the key dates, who should still sit SAP-C02, and how to study through the switch without wasted work.

AWS disaster recovery strategies, RTO and RPOBackup and restore, pilot light, warm standby and active/active on AWS, how RTO and RPO pick between them, and the services each strategy uses.

IAM users, roles and policies on AWSHow IAM users, roles, identity-based and resource-based policies, cross-account access, SCPs and permissions boundaries fit together for AWS exams.

SQS vs SNS vs EventBridge on AWSWhen to use an SQS queue, an SNS topic or an EventBridge bus, plus fan-out, FIFO ordering, visibility timeouts and dead-letter queues for AWS exams.

VPC endpoints vs NAT gateways on AWSWhen to use gateway endpoints, interface endpoints (PrivateLink) or a NAT gateway for private subnets, and the cost and security trade-offs exams test.