DBS-C01 Management and Operations Practice Question
A company has an Amazon RDS for MySQL DB instance with automated backups enabled. The database is 500 GB in size. The company wants to create a new test database from the current state with minimal impact on production. Which approach meets these requirements?
⚠ Common exam trap
Many candidates confuse the ability to create a manual snapshot from an automated backup (which is not supported) with the valid option of taking a new manual snapshot directly from the DB instance, leading them to choose option D incorrectly.
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
✓
Take a snapshot of the DB instance and restore it to a new instance.
Taking a snapshot of the RDS DB instance and restoring it to a new instance creates an independent copy of the database with minimal performance impact on the source. Snapshots are asynchronous and capture a consistent state without blocking writes, making this the most efficient method for creating a test database from the current production state.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Take a snapshot of the DB instance and restore it to a new instance.
Why this is correct
Snapshots are taken asynchronously with minimal performance impact, and restore creates a new instance.
- ✗
Create a read replica and promote it to a standalone instance.
Why it's wrong here
Creating a read replica puts additional load on the source during creation.
- ✗
Use mysqldump to export the database and import into a new instance.
Why it's wrong here
mysqldump can cause lock contention and performance impact on production.
- ✗
Create a manual DB snapshot from the automated backup and restore.
Why it's wrong here
Manual snapshot is similar to automated; but this approach still requires a snapshot.
Go deeper
Related to this question
About these practice questions
One of 1,663 original DBS-C01 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. 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.