DBS-C01 Amazon RDS storage optimization Practice Question
A database administrator notices that an Amazon RDS for SQL Server DB instance has been in the 'storage-optimization' state for several hours after modifying the storage type from gp2 to io1. What should the administrator do to resolve this?
⚠ Common exam trap
Candidates might think that rebooting or restoring from a snapshot could speed up the process, but these actions are either unnecessary or disruptive.
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
✓
Wait for the storage optimization to complete.
The 'storage-optimization' state is a normal part of the modification process when converting between storage types on RDS. It can take hours as the database migrates to the new storage configuration. The administrator should simply wait for the process to complete. Options B, C, and D are incorrect: restoring from a snapshot would lose recent changes and requires reapplication of the modification, modifying back to gp2 would interrupt the process and still require time, and rebooting does not affect the storage optimization.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Wait for the storage optimization to complete.
Why this is correct
Storage optimization is automatic and takes time; no action is needed.
- ✗
Restore from the latest snapshot and reapply the modification.
Why it's wrong here
This would cause unnecessary downtime and is not required.
- ✗
Cancel the modification by modifying the DB instance back to gp2.
Why it's wrong here
Modification is in progress; canceling would revert changes.
- ✗
Reboot the DB instance.
Why it's wrong here
Rebooting does not affect the storage optimization process.
Visual reference
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.