Courseiva

DBS-C01 · topic practice

Management and Operations practice questions

Practise AWS Certified Database Specialty DBS-C01 Management and Operations practice questions — original exam-style scenarios with answer choices, explanations, and analysis of common mistakes.

Courseiva uses original exam-style practice questions designed for learning and revision. The goal is to understand the concepts, recognise exam patterns, and improve through explanations — not memorise copied exam dumps.

Reviewed byJohnson Ajibi· MSc IT Security
20 questionsDomain: Management and Operations
Practice 10 questionsBrowse domain →

What the exam tests

What to know about Management and Operations

Management and Operations questions test whether you can apply the concept in context, not just recognise a definition.

How the topic appears in realistic exam-style scenarios.

Which detail in the question changes the correct answer.

How to eliminate plausible but wrong options.

How to connect the question back to the wider exam objective.

Watch out for

Common Management and Operations exam traps

  • ▸Answering from memory before reading the full scenario.
  • ▸Missing a constraint such as cost, availability, security, scope or command context.
  • ▸Choosing a broad answer when the question asks for the most specific fix.
  • ▸Ignoring why the wrong options are tempting.

Practice set

Management and Operations questions

20 questions · select your answer, then reveal the explanation

Question 1mediummulti select
Read the full Management and Operations explanation →

A company runs a production Amazon RDS for PostgreSQL DB instance. The database experiences intermittent high latency during peak hours. The company's monitoring shows that CPU utilization is below 40%, memory is adequate, and network throughput is normal. The DB instance uses General Purpose SSD (gp2) storage with 3,000 Provisioned IOPS. Which TWO actions should a database specialist take to diagnose and resolve the performance issue? (Choose two.)

Question 2mediummulti select
Read the full Management and Operations explanation →

Which TWO actions can help reduce the recovery time objective (RTO) for an Amazon RDS for PostgreSQL DB instance in the event of a failure? (Choose 2.)

Question 3mediummultiple choice
Read the full Management and Operations explanation →

A company's Amazon RDS for MySQL instance is experiencing high CPU utilization. The company's application is write-heavy. The database administrator wants to reduce the load on the primary instance. Which solution is MOST effective?

Question 4easymulti select
Read the full Management and Operations explanation →

A company wants to monitor the performance of an Amazon RDS for MySQL instance. Which TWO metrics are available in Amazon CloudWatch by default? (Choose 2.)

Question 5mediummultiple choice
Read the full Management and Operations explanation →

A database administrator runs the above CLI command. The DB instance has pending modifications. Which modification will take effect immediately without requiring a reboot?

Network Topology
aws rds describe-db-instancesdb-instance-identifier mydbquery 'DBInstances[0].PendingModifiedValues'Refer to the exhibit.```"MasterUserPassword": "****","DBInstanceClass": "db.r5.large","AllocatedStorage": 200,"BackupRetentionPeriod": 7
Question 6mediummultiple choice
Read the full Management and Operations explanation →

A database specialist sees the above output for an RDS MySQL instance. The application reports that the instance is not accepting writes. What is the most likely cause?

Network Topology
$ aws rds describe-db-instancesdb-instance-identifier mydbRefer to the exhibit.Output from AWS CLI:```"DBInstances": ["DBInstanceIdentifier": "mydb","DBInstanceClass": "db.r5.large","Engine": "mysql","DBInstanceStatus": "available","MultiAZ": false,"StorageType": "gp2","AllocatedStorage": 100,"Iops": 1000,"StorageEncrypted": true,"DBSubnetGroup": {"VpcId": "vpc-12345678"},"Endpoint": {"Address": "mydb.abcdefghijkl.us-east-1.rds.amazonaws.com","Port": 3306"ReadReplicaSourceDBInstanceIdentifier": "mydb-source","ReadReplicaDBInstanceIdentifiers": []
Question 7mediummultiple choice
Read the full Management and Operations explanation →

A company is using a Multi-AZ RDS for MySQL instance. The primary instance recently experienced an unexpected failover, and the application experienced a brief interruption. The database administrator wants to investigate the root cause. Which AWS service should be used to review the failover event and its details?

Question 8hardmulti select
Read the full Management and Operations explanation →

A company is running Amazon RDS for Oracle with a Multi-AZ deployment. The database is experiencing performance degradation due to high I/O waits. The team suspects that the issue is related to the transaction log (redo log) writes. Which THREE metrics should be monitored in Amazon CloudWatch to diagnose the issue?

Question 9hardmulti select
Read the full Management and Operations explanation →

A company is designing a disaster recovery plan for an Amazon RDS for Oracle DB instance. The primary region is us-east-1, and the DR region is us-west-2. The RPO must be less than 5 minutes, and the RTO must be less than 15 minutes. Which THREE actions should be taken? (Choose THREE.)

Question 10hardmultiple choice
Read the full Management and Operations explanation →

A company uses Amazon DynamoDB with global tables in a multi-Region active-active configuration. The application writes to the table in us-east-1 and reads from us-west-2. Recently, a network partition occurred between the two regions, and after recovery, some data was lost. What is the most likely reason for the data loss?

Question 11mediummultiple choice
Read the full Management and Operations explanation →

A database administrator sees repeated 'Aborted connection' warnings in the RDS for MySQL error log. The application team reports intermittent connection errors. What is the most likely cause of these aborted connections?

Exhibit

Refer to the exhibit.

Exhibit: Amazon RDS for MySQL error log snippet
```
2023-06-01 10:00:00 1234567890 [Warning] Aborted connection 1234567890 to db: 'mydb' user: 'appuser' host: '10.0.0.50' (Got an error reading communication packets)
```
Question 12easymultiple choice
Read the full Management and Operations explanation →

A database specialist is configuring an Amazon RDS for PostgreSQL instance with automated backups enabled. The backup retention period is set to 7 days. The instance experiences a failure and becomes unavailable. What is the maximum amount of time the specialist has to recover the database to the most recent possible point in time?

Question 13mediummultiple choice
Read the full Management and Operations explanation →

A company is running an Amazon RDS for MySQL Multi-AZ DB instance. The primary instance in us-east-1a experiences an unexpected failure. After the automatic failover, the application team reports that write latency has increased significantly. The new primary instance is in us-east-1b. The DB instance class and storage configuration are identical. What is the MOST likely cause of the increased write latency?

Question 14hardmultiple choice
Read the full Management and Operations explanation →

A database administrator is troubleshooting an Amazon RDS for PostgreSQL DB instance that is experiencing high CPU utilization. The administrator runs the following query to find the current running queries:

SELECT pid, now() - pg_stat_activity.query_start AS duration, query, state FROM pg_stat_activity WHERE state = 'active';

The output shows a high number of queries with a state of 'active' and durations exceeding several minutes. What should the administrator do FIRST to reduce CPU utilization?

Question 15easymultiple choice
Read the full Management and Operations explanation →

A company is using Amazon DynamoDB with on-demand capacity mode. The application experiences occasional throttling during peak hours. The operations team wants to reduce throttling without changing the application code. What should they do?

Question 16hardmultiple choice
Read the full Management and Operations explanation →

A company is migrating an on-premises Microsoft SQL Server database to Amazon RDS for SQL Server. The database uses SQL Server Agent jobs, custom CLR assemblies, and cross-database queries. Which of the following will require modification before migration?

Question 17mediummultiple choice
Read the full Management and Operations explanation →

A company is using Amazon RDS for MySQL with a cross-Region read replica to support disaster recovery. The primary DB instance is in us-west-2, and the read replica is in us-east-1. The read replica is used for reporting and also serves as a failover target. The operations team notices that the read replica lag is consistently above 10 seconds during peak hours. What should the team do to reduce replica lag?

Question 18mediummulti select
Read the full Management and Operations explanation →

A company is using an Amazon Aurora MySQL DB cluster. The company wants to implement a backup strategy that supports point-in-time recovery (PITR) with a recovery time objective (RTO) of 15 minutes and a recovery point objective (RPO) of 5 minutes. Which TWO actions should the company take?

Question 19hardmulti select
Read the full Management and Operations explanation →

A company is running a production Amazon DynamoDB table with on-demand capacity. The table experiences occasional throttling during traffic spikes. The table's partition key is a timestamp, and the workload is write-heavy. The operations team needs to reduce throttling. Which THREE actions should the team take? (Choose three.)

Question 20hardmultiple choice
Read the full Management and Operations explanation →

A database administrator runs the above AWS CLI command to troubleshoot replication issues. The DB instance 'mydb' is a read replica of 'my-source-db'. The administrator notices that the replica lag is increasing. Which of the following is the MOST likely cause?

Network Topology
db-instance-identifier mydbquery 'DBInstances[0].[DBInstanceIdentifieroutput jsonRefer to the exhibit."mydb","db.r5.large","mysql","8.0.28","available",false,null,"arn:aws:rds:us-east-1:123456789012:db:my-source-db"
Continue with 20-question session →

Free account

Track your progress over time

Create a free account to save your results and see which topics improve across sessions.

Sign up freeLog in

Focused Management and Operations sessions

Start a Management and Operations only practice session

Every question in these sessions is drawn from the Management and Operations domain — nothing else.

10 questions20 questions30 questions50 questions
Browse all Management and Operations questions →Mixed DBS-C01 session

Related practice questions

Related DBS-C01 topic practice pages

Move into related areas when this topic feels solid.

Workload-Specific Database Design practice questions

Practise DBS-C01 questions linked to Workload-Specific Database Design.

Deployment and Migration practice questions

Practise DBS-C01 questions linked to Deployment and Migration.

Management and Operations practice questions

Practise DBS-C01 questions linked to Management and Operations.

Monitoring and Troubleshooting practice questions

Practise DBS-C01 questions linked to Monitoring and Troubleshooting.

Database Security practice questions

Practise DBS-C01 questions linked to Database Security.

DBS-C01 fundamentals practice questions

Practise DBS-C01 questions linked to DBS-C01 fundamentals.

DBS-C01 scenario practice questions

Practise DBS-C01 questions linked to DBS-C01 scenario.

DBS-C01 troubleshooting practice questions

Practise DBS-C01 questions linked to DBS-C01 troubleshooting.

Frequently asked questions

What does the DBS-C01 exam test about Management and Operations?
Management and Operations questions test whether you can apply the concept in context, not just recognise a definition.
How should I use these practice questions?
Select your answer before revealing the explanation. Then read why each option is right or wrong — this active recall approach builds retention far faster than re-reading notes.
Can I practise just Management and Operations questions in a focused session?
Yes — the session launcher on this page draws every question from the Management and Operations domain. Use a 10-question session first to gauge your baseline, then move to 20 or 30 once the weak spots are clear.
Where can I practise other DBS-C01 topics?
Use the topic links above to move to related areas, or go back to the DBS-C01 question bank to see all topics.
Are these real exam questions or dumps?
These are original practice questions written to test the same concepts the DBS-C01 exam covers. They are not copied from any real exam or dump site.