Courseiva
← DBS-C01
Full test
Management and Operations →easyMultiple ChoiceObjective-mapped

DBS-C01 Management and Operations Practice Question

Network Topology
$ aws rds describe-db-instancesdb-instance-identifier mydbRefer to the exhibit.```"DBInstances": ["DBInstanceIdentifier": "mydb","DBInstanceClass": "db.m5.large","Engine": "mysql","DBInstanceStatus": "available","MasterUsername": "admin","Endpoint": {"Address": "mydb.xxxxxxx.us-east-1.rds.amazonaws.com","Port": 3306},"AllocatedStorage": 500,"StorageType": "gp2","MultiAZ": true,"PubliclyAccessible": false,"BackupRetentionPeriod": 35,"DBParameterGroups": ["DBParameterGroupName": "default.mysql8.0","ParameterApplyStatus": "in-sync"

A database administrator is reviewing the configuration of an RDS MySQL instance. Based on the exhibit, which change would MOST improve the database's performance under heavy write workloads without increasing costs significantly?

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

✓

Change the storage type from gp2 to gp3 to get higher baseline IOPS and throughput.

Gp3 storage provides higher baseline IOPS and throughput than gp2 at the same cost, which directly improves performance under heavy write workloads. Option A is incorrect because parameter group tuning can help but is not the most impactful change without additional cost. Option B is incorrect because backup retention period does not affect performance. Option C is incorrect because Multi-AZ provides high availability, not improved write performance.

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 DB parameter group to a custom one with optimized MySQL parameters.

    Why it's wrong here

    While parameter tuning can help, the default group is often acceptable; storage upgrade is more impactful.

  • ✗

    Increase the backup retention period to 35 days to improve performance.

    Why it's wrong here

    Backup retention does not affect runtime performance.

  • ✗

    Enable Multi-AZ to improve write performance.

    Why it's wrong here

    Multi-AZ is already enabled and does not directly improve write performance.

  • ✓

    Change the storage type from gp2 to gp3 to get higher baseline IOPS and throughput.

    Why this is correct

    gp3 offers better performance per dollar than gp2.

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 →

How Courseiva writes practice questions · Editorial policy

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.