Amazon RDS for MySQL is the correct choice because it provides a fully managed relational database engine that natively supports ACID transactions, which are essential for maintaining data integrity during inventory updates in an e-commerce product catalog. The highly structured data with relationships between products, categories, and suppliers maps directly to MySQL’s relational model using foreign keys and joins, while its efficient handling of moderate read and write traffic makes it ideal for this workload. On the AWS Certified Database Specialty DBS-C01 exam, this scenario tests your ability to distinguish between relational and NoSQL services—a common trap is choosing DynamoDB for its scalability, but DynamoDB lacks native multi-table ACID transactions and foreign key support. Remember the memory tip: “If you need joins and rollbacks, RDS MySQL is the one that fits the box.”
DBS-C01 Workload-Specific Database Design Practice Question
This DBS-C01 practice question tests your understanding of workload-specific database design. Match the stated requirement to the specific cloud service, access model, or configuration option — many options are valid in isolation but not for this scenario. 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 company is designing a database for an e-commerce application that needs to store product catalog data. The data is highly structured with relationships between products, categories, and suppliers. The application requires ACID transactions to maintain data integrity when updating inventory. The company expects moderate read and write traffic. Which AWS database service is MOST suitable for this workload?
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Amazon RDS for MySQL
Amazon RDS for MySQL is the most suitable choice because it provides a fully managed relational database that supports ACID transactions, which are essential for maintaining data integrity during inventory updates. The highly structured nature of product catalog data with relationships between products, categories, and suppliers maps naturally to MySQL's relational model with foreign keys and joins. RDS for MySQL handles moderate read/write traffic efficiently and offers features like Multi-AZ for high availability and read replicas for scaling reads.
Key principle: Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
✗
Amazon ElastiCache for Redis
Why it's wrong here
ElastiCache is a caching service, not a durable database for ACID transactions.
✗
Amazon Neptune
Why it's wrong here
Neptune is a graph database, which is overkill for simple relational data.
✓
Amazon RDS for MySQL
Why this is correct
RDS for MySQL provides full ACID compliance and supports relational data structures.
Related concept
Read the scenario before looking for a memorised answer.
✗
Amazon DynamoDB
Why it's wrong here
DynamoDB is NoSQL and does not natively support complex joins and ACID transactions across multiple items.
Common exam traps
Common exam trap: answer the scenario, not the keyword
The trap here is that candidates often pick Amazon DynamoDB for its scalability and performance, but overlook the requirement for ACID transactions and relational joins, which DynamoDB handles poorly compared to a traditional RDBMS like MySQL.
Detailed technical explanation
How to think about this question
Under the hood, MySQL uses InnoDB as its default storage engine, which provides row-level locking, multi-version concurrency control (MVCC), and full ACID compliance through redo logs and undo logs. In a real-world e-commerce scenario, an inventory update transaction might involve decrementing a product's stock count and inserting an order record in a single atomic operation; MySQL's COMMIT and ROLLBACK ensure that either both operations succeed or neither is applied, preventing overselling. RDS for MySQL also supports automated backups, point-in-time recovery, and performance insights, making it a robust choice for moderate traffic patterns.
KKey Concepts to Remember
Read the scenario before looking for a memorised answer.
Find the constraint that changes the correct option.
Eliminate answers that are true in general but not in this case.
TExam Day Tips
→Watch for words such as best, first, most likely and least administrative effort.
→Review why wrong options are wrong, not only why the correct option is correct.
Key takeaway
Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
Real-world example
How this comes up in practice
An e-commerce site experiences heavy traffic on Black Friday and near-zero traffic during off-peak weeks. Rather than provisioning permanent large VMs, the team uses auto-scaling groups that add capacity automatically under load and reduce it overnight. Questions like this test whether you understand elasticity, availability zones, and cloud compute scaling patterns.
What to study next
Got this wrong? Here's your next step.
Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.
Workload-Specific Database Design — This question tests Workload-Specific Database Design — Read the scenario before looking for a memorised answer..
What is the correct answer to this question?
The correct answer is: Amazon RDS for MySQL — Amazon RDS for MySQL is the most suitable choice because it provides a fully managed relational database that supports ACID transactions, which are essential for maintaining data integrity during inventory updates. The highly structured nature of product catalog data with relationships between products, categories, and suppliers maps naturally to MySQL's relational model with foreign keys and joins. RDS for MySQL handles moderate read/write traffic efficiently and offers features like Multi-AZ for high availability and read replicas for scaling reads.
What should I do if I get this DBS-C01 question wrong?
Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.
What is the key concept behind this question?
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 →
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.
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.