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 1mediummultiple 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 2hardmultiple 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 3easymultiple 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 4hardmultiple 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 5mediummultiple 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 6mediummulti 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 7hardmulti 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 8hardmultiple 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"
Question 9easymultiple choice
Read the full Management and Operations explanation →

An IAM policy is attached to a user who needs to restore an Amazon RDS DB instance from a DB snapshot. The user attempts to restore and receives an 'Access Denied' error. Which missing permission is MOST likely causing the failure?

Exhibit

Refer to the exhibit.

Policy:
{
    "Version": "2012-10-17",
    "Statement": [
        {
            "Sid": "RestoreFromSnapshot",
            "Effect": "Allow",
            "Action": [
                "rds:RestoreDBInstanceFromDBSnapshot",
                "rds:DescribeDBSnapshots",
                "ec2:DescribeSecurityGroups",
                "ec2:DescribeSubnets"
            ],
            "Resource": "*"
        }
    ]
}
Question 10hardmultiple choice
Read the full Management and Operations explanation →

A company's Amazon RDS for PostgreSQL instance is experiencing high CPU utilization. The DB instance is a db.r5.xlarge with 500 GB of General Purpose SSD (gp2) storage. The application team reports that write-intensive batch jobs are causing latency. The DBA notices that the ReadIOPS metric is low but WriteIOPS is consistently near the instance's maximum. Which action would most effectively reduce write latency?

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

A developer accidentally deleted a critical table from an Amazon RDS for MySQL DB instance. Automated backups are enabled with a retention period of 7 days. The deletion occurred 3 hours ago. What is the fastest way to restore the deleted table without affecting other tables?

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

A company runs an Amazon Aurora MySQL database cluster with a primary instance and two Aurora Replicas. The application is experiencing occasional deadlocks on the primary instance during peak hours. The deadlocks cause transaction rollbacks that impact customer experience. Which design change should the company implement to minimize deadlocks?

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

A company is using Amazon DynamoDB for a gaming leaderboard. The table has a partition key of 'game_id' and a sort key of 'score'. The application performs a query to retrieve the top 10 scores for a given game_id. The query uses ScanIndexForward: false and Limit: 10. Recently, the query response time has increased. The table's read capacity is 1000 RCU, and the average item size is 1 KB. Which is the most likely cause of the increased latency?

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

A company is migrating an on-premises Oracle database to Amazon RDS for Oracle. The database is 2 TB and has a high number of small transactions. The company needs to minimize downtime during the migration. Which TWO strategies should be used together? (Choose two.)

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

A company is using Amazon ElastiCache for Redis to cache frequently accessed data from an RDS MySQL database. The cache hit ratio is currently 85%. The operations team notices that during traffic spikes, the cache eviction rate increases significantly, and the database CPU utilization spikes. The cache cluster uses a single r6g.large node. Which THREE actions should the team take to improve performance? (Choose three.)

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

A company runs a critical e-commerce application on Amazon RDS for PostgreSQL with a db.r5.2xlarge instance and 500 GB of gp2 storage. The application experiences periodic write spikes during flash sales. During these events, the WriteIOPS metric exceeds the provisioned baseline IOPS of 1,500, and the database becomes unresponsive for several seconds. The DBA has configured a CloudWatch alarm on WriteIOPS, but the alarm triggers after the performance issue occurs. The company needs to ensure that the database can handle these spikes without downtime. The budget allows for moderate cost increases. What should the DBA do?

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

A company runs a production Amazon RDS for MySQL Multi-AZ DB instance with 10 TB of storage. The application team notices that database write latency has increased from 5 ms to 80 ms over the past week. The DB instance is a db.r5.8xlarge with 500 GB of gp2 storage. CloudWatch metrics show WriteIOPS averaging 10,000, WriteThroughput at 50 MB/s, and BurstBalance decreasing from 100% to 20% over the same period. The DB instance has no reserved IOPS. The database workload is write-heavy with frequent small transactions. The company needs to resolve the high write latency while minimizing costs and downtime. Which solution should the database specialist recommend?

Question 18mediummulti 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 19hardmultiple choice
Read the full Management and Operations explanation →

A database specialist sees the above error log entries from an Amazon RDS for MySQL DB instance. Which action should be taken to resolve the issue?

Exhibit

Refer to the exhibit. A database specialist receives the following Amazon CloudWatch Logs excerpt from an Amazon RDS for MySQL DB instance:

2024-11-15 10:23:45 UTC [ERROR] [MY-013118] [InnoDB] Page [page id: space=5, page number=1234] log sequence number 567890 is in the future! Current system log sequence number 567800.
2024-11-15 10:23:46 UTC [ERROR] [MY-011825] [InnoDB] Unable to purge a record because it is in a non-tablespace page.
2024-11-15 10:24:01 UTC [ERROR] [MY-013114] [InnoDB] Database page corruption on disk or a failed file read of page [page id: space=5, page number=1235]. You may have to recover from a backup.
Question 20easymultiple choice
Read the full Management and Operations explanation →

A company is migrating its on-premises Oracle database to Amazon RDS for Oracle. The database is 2 TB in size and contains both transactional and analytical workloads. The company uses Oracle Data Pump for migration. During the migration, the database specialist notices that the export job on the source database is taking longer than expected and is generating significant I/O, impacting production performance. The company needs to minimize the impact on the source database while completing the migration within a 48-hour window. The source database is currently running on a dedicated server with sufficient CPU and memory. Which course of action should the database specialist take?

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.