DBS-C01 Management and Operations Practice Question
A multinational e-commerce company runs an Amazon Aurora MySQL database for its product catalog. The database is 2 TB and has a high write volume. The company needs to create a test environment that contains a subset (10%) of the production data for developers to use. The test environment must be refreshed daily with the latest production data. The operations team wants to minimize cost and ensure that the test environment does not impact production performance. Which solution should they implement?
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 Aurora cloning to create a clone of the production cluster. Use database triggers or scripts to delete 90% of the data after cloning.
Using Aurora cloning creates a storage-level copy that shares the same underlying storage as the source cluster, minimizing cost and avoiding any performance impact on production because cloning does not involve copying data. After cloning, you can delete 90% of the data using scripts or triggers to retain only 10% for testing. Option A (DMS continuous replication) would incur additional cost and ongoing replication overhead. Option B (snapshot and restore) would create a full 2 TB copy and then you would have to delete data, incurring storage costs for the full copy. Option D (read replica) would impact production replication and would also require deleting data after promotion.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Use AWS DMS to continuously replicate a filtered subset of data to a test cluster.
Why it's wrong here
DMS adds complexity and cost.
- ✗
Take a manual snapshot of the production cluster, restore it to a new cluster, and delete 90% of the data.
Why it's wrong here
Snapshot restore takes time and storage cost for full data.
- ✓
Use Aurora cloning to create a clone of the production cluster. Use database triggers or scripts to delete 90% of the data after cloning.
Why this is correct
Cloning is fast, cost-effective, and does not impact production.
- ✗
Create a read replica of the production cluster, promote it to a standalone cluster, and delete 90% of the data.
Why it's wrong here
Read replica creation impacts production I/O.
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.