DBS-C01 Workload-Specific Database Design Practice Question
Exhibit
Refer to the exhibit.
=== CloudFormation Snippet ===
Resources:
MyDBInstance:
Type: AWS::RDS::DBInstance
Properties:
Engine: MySQL
DBInstanceClass: db.r5.large
MultiAZ: true
StorageType: gp2
AllocatedStorage: 200
DBSubnetGroupName: !Ref MyDBSubnetGroup
VPCSecurityGroups:
- !Ref MyDBSecurityGroup
BackupRetentionPeriod: 7
PreferredBackupWindow: '02:00-03:00'
PreferredMaintenanceWindow: 'sun:04:00-sun:05:00'
DBInstanceIdentifier: MyProdDB
MasterUsername: admin
MasterUserPassword: '{{resolve:secretsmanager:MyProdDBSecret}}'A company is deploying an RDS MySQL database using the above CloudFormation template. After deployment, the database automatically reboots during the maintenance window. The company wants to reduce the impact of maintenance events. Which parameter change would minimize unavailability?
⚠ Common exam trap
Watch out — candidates often assume changing the maintenance window to a less busy time (Option D) reduces impact, but it only shifts the downtime without reducing its length. The correct answer (AutoMinorVersionUpgrade to true) ensures minor version upgrades are applied during the maintenance window, avoiding additional downtime from manual upgrades. However, note that AutoMinorVersionUpgrade does not enable Multi-AZ failover; that is a separate feature.
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
✓
Set AutoMinorVersionUpgrade to true in the template.
Setting AutoMinorVersionUpgrade to true ensures that minor version upgrades are applied automatically during the maintenance window. This prevents the need for a separate, manually scheduled maintenance event to apply these upgrades, thereby reducing the overall number of maintenance-related reboots and minimizing unavailability compared to the other options. Option B increases recovery points but does not reduce downtime; Option C improves performance but not maintenance impact; Option D shifts the downtime but does not reduce its length.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Set AutoMinorVersionUpgrade to true in the template.
Why this is correct
Automatic minor version upgrades ensure the database is updated during maintenance windows, reducing the need for manual updates that could cause longer downtime.
- ✗
Increase BackupRetentionPeriod to 30 days to have more recovery points.
Why it's wrong here
Backup retention does not affect maintenance impact.
- ✗
Increase AllocatedStorage to 500 GB to improve performance during maintenance.
Why it's wrong here
Storage size does not reduce maintenance downtime.
- ✗
Change PreferredMaintenanceWindow to a less busy time.
Why it's wrong here
Changing the time does not reduce the duration of the impact.
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.