DBS-C01 Monitoring and Troubleshooting Practice Question
A company is using Amazon RDS for SQL Server with native backup and restore. The backup process is failing with an error indicating insufficient disk space for the backup file. The DB instance has 200 GB of allocated storage, and the backup file is 50 GB. What should the database administrator do to resolve this issue?
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
✓
Increase the allocated storage for the RDS instance
Native backups in RDS for SQL Server are stored in the instance's attached storage. When the allocated storage is full, the backup fails due to insufficient disk space. Increasing the allocated storage provides additional space for the backup file. Option A is incorrect because changing to Provisioned IOPS affects performance, not storage capacity. Option C is incorrect because the error is about disk space, not permissions. Option D is incorrect because switching to automated backups would not resolve the immediate failure of the native backup process, and the question specifically addresses native backup failure.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Change the storage type to Provisioned IOPS for better performance
Why it's wrong here
Performance is not the issue; space is.
- ✓
Increase the allocated storage for the RDS instance
Why this is correct
More storage space allows the backup file to be written.
- ✗
Grant the rds_backup user additional permissions to write to S3
Why it's wrong here
The error is about disk space, not S3 permissions.
- ✗
Switch to automated backups instead of native backups
Why it's wrong here
Automated backups also require free storage space for the backup process.
Visual reference
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.