Quick Answer
Amazon Aurora Serverless v2 is the correct choice because it automatically scales compute and memory in fine-grained increments down to 1 Aurora Capacity Unit (ACU), making it ideal for a startup handling both transactional (OLTP) and analytical (OLAP) workloads with unpredictable traffic. Unlike provisioned Aurora or RDS, which require manual scaling and incur costs even at low utilization, Aurora Serverless v2’s pay-per-ACU model eliminates idle waste while supporting mixed workloads through the MySQL/PostgreSQL-compatible engine. On the AWS Certified Database Specialty DBS-C01 exam, this scenario tests your ability to distinguish between serverless and provisioned options, with a common trap being Aurora Serverless v1 (which pauses after inactivity and lacks fine-grained scaling) or DynamoDB (which is NoSQL and not optimized for analytical queries). Remember the key differentiator: Aurora Serverless v2 handles both OLTP and OLAP without pausing, scaling instantly from 1 ACU upward. A useful memory tip is “v2 for two”—it supports both workload types and scales in two directions (up and down) automatically.
This DBS-C01 practice question tests your understanding of workload-specific database design. Read the scenario carefully and evaluate each option against the stated constraints before committing to an answer. After answering, compare your reasoning against the explanation and wrong-answer breakdown below. Once you have made your selection, read the full explanation to reinforce the concept and understand why each distractor is designed to mislead on exam day.
A startup needs a cost-effective database for a small application that handles both transactional and analytical workloads. They expect low traffic initially but want the database to automatically scale as the business grows. Which database solution is BEST suited?
Clue words in this question
Noticing these words before you look at the options changes how you read each choice.
Clue: "best"
Why it matters: Signals that multiple options may be partially correct. Choose the option that most directly solves the exact problem described, not the one that sounds most complete.
Amazon Aurora Serverless v2
Automatically scales capacity and is cost-effective for variable workloads.
Amazon DynamoDB with on-demand capacity
Why wrong: DynamoDB is NoSQL, not suitable for complex analytical queries.
Amazon RDS for MySQL with a Single-AZ deployment
Why wrong: Does not automatically scale; requires manual scaling.
Amazon Redshift Serverless
Why wrong: Redshift is optimized for analytics, not transactional workloads.
Answer choices
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
Amazon Aurora Serverless v2
Amazon Aurora Serverless v2 is the best fit because it automatically scales compute and memory capacity in fine-grained increments (down to 1 ACU) based on actual workload demand, supporting both transactional (OLTP) and analytical (OLAP) queries via the MySQL/PostgreSQL-compatible Aurora engine. It offers a pay-per-ACU model that is cost-effective for low-traffic startups while providing near-instant scaling to handle growth without manual intervention.
Key principle: Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
Answer analysis
For each option: why learners choose it and why it is or isn't the right answer here.
Amazon Aurora Serverless v2
Why this is correct
Automatically scales capacity and is cost-effective for variable workloads.
Clue confirmation
The clue word "best" in the question point toward this answer.
Related concept
Read the scenario before looking for a memorised answer.
Amazon DynamoDB with on-demand capacity
Why it's wrong here
DynamoDB is NoSQL, not suitable for complex analytical queries.
Amazon RDS for MySQL with a Single-AZ deployment
Why it's wrong here
Does not automatically scale; requires manual scaling.
Amazon Redshift Serverless
Why it's wrong here
Redshift is optimized for analytics, not transactional workloads.
Common exam traps
The trap here is that candidates often confuse 'serverless' with 'NoSQL' (DynamoDB) or assume that any 'serverless' database (Redshift Serverless) can handle mixed workloads, but the key differentiator is the need for relational SQL support for both transactional and analytical queries, which only Aurora Serverless v2 provides among the options.
Detailed technical explanation
Aurora Serverless v2 uses a shared storage volume that decouples compute from storage, allowing ACU (Aurora Capacity Unit) scaling in 0.5 ACU increments with sub-second latency, while maintaining full MySQL/PostgreSQL compatibility for both transactional and analytical queries. Under the hood, it leverages a distributed, multi-tenant fleet of warm pools to rapidly allocate capacity, and it supports reader endpoints for read-heavy analytical workloads without impacting write performance. In a real-world scenario, a startup with a customer-facing app that runs monthly reports can use Aurora Serverless v2 to avoid over-provisioning during low-traffic periods and automatically scale during peak reporting cycles.
Key takeaway
Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
Real-world example
A startup's cloud architect reviews their monthly bill and notices costs are higher than expected for a long-running batch job. Switching from on-demand instances to Reserved Instances — or using Spot/Preemptible VMs — can reduce compute costs by up to 72 %. Questions like this test whether you understand the tradeoffs between commitment, flexibility, and cost across cloud pricing models.
What to study next
Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.
Workload-Specific Database Design — study guide chapter
Learn the concepts, then practise the questions
Workload-Specific Database Design practice questions
Targeted practice on this topic area only
All DBS-C01 questions
1,730 questions across all exam domains
AWS Certified Database Specialty DBS-C01 study guide
Full concept coverage aligned to exam objectives
DBS-C01 practice test guide
How to use practice tests most effectively before exam day
Related practice questions
Use these pages to review the topic behind this question. This is how one missed question becomes focused revision.
Practise DBS-C01 questions linked to Workload-Specific Database Design.
Practise DBS-C01 questions linked to Deployment and Migration.
Practise DBS-C01 questions linked to Management and Operations.
Practise DBS-C01 questions linked to Monitoring and Troubleshooting.
Practise DBS-C01 questions linked to Database Security.
Practise DBS-C01 questions linked to DBS-C01 fundamentals.
Practise DBS-C01 questions linked to DBS-C01 scenario.
Practise DBS-C01 questions linked to DBS-C01 troubleshooting.
Practice this exam
Short sessions build daily habit. Longer sessions build exam-day stamina. Try a timed session to simulate real conditions.
FAQ
Workload-Specific Database Design — This question tests Workload-Specific Database Design — Read the scenario before looking for a memorised answer..
The correct answer is: Amazon Aurora Serverless v2 — Amazon Aurora Serverless v2 is the best fit because it automatically scales compute and memory capacity in fine-grained increments (down to 1 ACU) based on actual workload demand, supporting both transactional (OLTP) and analytical (OLAP) queries via the MySQL/PostgreSQL-compatible Aurora engine. It offers a pay-per-ACU model that is cost-effective for low-traffic startups while providing near-instant scaling to handle growth without manual intervention.
Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.
Yes — watch for: "best". Signals that multiple options may be partially correct. Choose the option that most directly solves the exact problem described, not the one that sounds most complete.
Read the scenario before looking for a memorised answer.
About these practice questions
Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →
Same concept, more angles
These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.
Variation 1. A startup needs a fully managed, serverless database for a new web application with unpredictable traffic. The application requires ACID transactions and SQL queries. Which AWS database service should they use?
easyWhy C: Amazon Aurora Serverless v2 is the correct choice because it provides a fully managed, serverless relational database that automatically scales capacity based on application demand, supports ACID transactions, and uses standard SQL queries. It is ideal for unpredictable traffic patterns as it can scale from zero to hundreds of thousands of transactions per minute without manual intervention.
Last reviewed: Jun 24, 2026
This DBS-C01 practice question is part of Courseiva's free Amazon Web Services certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DBS-C01 exam.
Question Discussion
Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.
Sign in to join the discussion.