DBS-C01 Workload-Specific Database Design Practice Question
An e-commerce company uses Amazon RDS for MySQL to store order data. They need to run complex analytical queries on the data without impacting the performance of the transactional workload. Which TWO solutions should they implement? (Choose TWO.)
⚠ Common exam trap
Watch out — candidates often confuse Multi-AZ read replicas with the standby instance, mistakenly believing the standby can serve queries, when in fact only a dedicated read replica (Option E) can offload read traffic for analytics.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Use Amazon Redshift for analytics and load data via AWS DMS
Amazon Redshift is purpose-built for complex analytical queries on large datasets, and AWS DMS can continuously replicate data from RDS for MySQL into Redshift without impacting the source transactional workload. This separates OLTP and OLAP environments, ensuring performance isolation.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Migrate the transaction table to Amazon DynamoDB
Why it's wrong here
DynamoDB does not support complex JOINs or analytical queries.
- ✓
Use Amazon Redshift for analytics and load data via AWS DMS
Why this is correct
Redshift is purpose-built for analytics; DMS can replicate data from RDS.
- ✗
Store order data in Amazon S3 and query with Amazon Athena
Why it's wrong here
While possible, it is not a direct solution without additional ETL.
- ✗
Enable Multi-AZ to use the standby for queries
Why it's wrong here
The standby is not accessible for read queries.
- ✓
Create an Amazon RDS read replica for analytical queries
Why this is correct
Read replicas can handle SELECT queries without affecting the primary.
Go deeper
Related to this question
About these practice questions
This DBS-C01 question is part of Courseiva's 1,663-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
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.