DBS-C01 Management and Operations Practice Question
A company's RDS for SQL Server instance has been running for 3 years. The DBA notices that the DB instance's allocated storage (500 GB) is 80% full. The application is write-heavy. The DBA needs to increase storage without downtime. What is the most efficient way to achieve this?
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 the Modify DB Instance API to increase allocated storage.
RDS for SQL Server supports modifying storage online using the Modify DB Instance API without downtime. Option A is incorrect because you cannot attach additional EBS volumes directly to an RDS instance; RDS manages its own storage. Option B is incorrect because creating a new instance and migrating data would require downtime. Option C is incorrect because taking a snapshot and restoring a new instance also incurs downtime and is less efficient than modifying storage in place.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Attach an additional EBS volume to the DB instance.
Why it's wrong here
RDS does not support attaching EBS volumes directly.
- ✗
Create a new DB instance with larger storage and migrate data.
Why it's wrong here
This requires downtime during migration.
- ✗
Take a snapshot and restore a new instance with larger storage.
Why it's wrong here
Restore takes time and may cause downtime.
- ✓
Use the Modify DB Instance API to increase allocated storage.
Why this is correct
RDS allows storage modification online for SQL Server.
Go deeper
Related to this question
About these practice questions
Courseiva writes every DBS-C01 question from scratch — 1,663 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or 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.