Courseiva

DBS-C01 · topic practice

Monitoring and Troubleshooting practice questions

Practise AWS Certified Database Specialty DBS-C01 Monitoring and Troubleshooting 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: Monitoring and Troubleshooting

What the exam tests

What to know about Monitoring and Troubleshooting

Monitoring and Troubleshooting 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 Monitoring and Troubleshooting 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

Monitoring and Troubleshooting questions

20 questions · select your answer, then reveal the explanation

An organization is using Amazon DynamoDB with on-demand capacity. They notice that the 'ThrottledRequests' metric is non-zero during a specific hour each day. The table stores session data and has a partition key of 'user_id'. The workload is uniform. What is the most likely cause of throttling?

You are managing an Amazon RDS for PostgreSQL Multi-AZ DB instance that handles a high-traffic e-commerce application. Recently, the database has been experiencing intermittent slowdowns during peak hours. You have enabled Enhanced Monitoring and Performance Insights. After reviewing the Performance Insights dashboard, you notice that the 'db.sql.queries.avg_latency' metric spikes during the slowdowns, and the top SQL queries are all simple SELECT statements on a frequently accessed 'orders' table. The table has over 10 million rows and is indexed on 'order_id', 'customer_id', and 'order_date'. The average query latency for these SELECT statements jumps from 5 ms to over 500 ms during the spikes. You also observe that the 'ReadIOPS' metric on the DB instance is consistently below the provisioned IOPS limit of the gp2 storage. The DB instance type is db.r5.large with 16 GB memory. The 'DatabaseConnections' metric shows that the number of connections is well within the max_connections limit (set to 200). However, the 'CPUCreditBalance' for the underlying EC2 instance, which is a T3 medium, drops to near zero during the spikes. The 'CPUUtilization' metric is below 50%. Which of the following is the MOST likely cause and the appropriate action to resolve the issue?

A company is running a production Amazon RDS for Oracle DB instance. The database specialist is setting up monitoring to detect and troubleshoot performance issues. Which TWO metrics should be used to identify whether the database is experiencing I/O bottlenecks?

A company is troubleshooting a performance issue with an Amazon RDS for MariaDB instance. The CloudWatch metric 'ReadIOPS' is consistently high, but 'WriteIOPS' is low. Which TWO actions could help improve read performance?

A team is troubleshooting an Amazon Aurora MySQL cluster where the writer instance fails over unexpectedly every few days. The failover is not triggered by manual intervention or maintenance events. CloudWatch metrics show that the failover occurs when the replica lag on the reader instances spikes to over 10 seconds. What is the MOST likely cause of the failover?

A financial services company runs a critical application on Amazon DynamoDB. Recently, they observed increased latency and throttled requests. Upon reviewing CloudWatch metrics, they see that WriteCapacityUnits consumed is consistently below the provisioned capacity, but ReadCapacityUnits consumed is frequently at 100%. The application performs equal mix of strongly consistent reads and writes. What is the most likely cause of the throttling?

Refer to the exhibit. An IAM policy attached to an IAM role used by an AWS Lambda function. The Lambda function is invoked by Amazon API Gateway and reads from a DynamoDB table. The function is experiencing permission errors when calling DynamoDB GetItem. What is the most likely cause?

Exhibit

{
  "Version": "2012-10-17",
  "Statement": [
    {
      "Sid": "AllowLambdaInvocation",
      "Effect": "Allow",
      "Action": "lambda:InvokeFunction",
      "Resource": "arn:aws:lambda:us-east-1:123456789012:function:MyFunction"
    },
    {
      "Sid": "AllowDynamoDBRead",
      "Effect": "Allow",
      "Action": [
        "dynamodb:GetItem",
        "dynamodb:Query"
      ],
      "Resource": "arn:aws:dynamodb:us-east-1:123456789012:table/MyTable"
    }
  ]
}

Which THREE metrics should be monitored to troubleshoot a slow Amazon Redshift query? (Choose three.)

A company is using Amazon RDS for MySQL with Multi-AZ deployment. The application team reports that write latency has increased significantly over the past hour. CloudWatch shows elevated 'ReadLatency' and 'WriteLatency' metrics. The DB instance is a db.r5.large with 500 GB General Purpose SSD (gp2) storage. Which action is most likely to resolve the issue?

A database administrator is troubleshooting a slow-running query on an Amazon RDS for MySQL DB instance. Which CloudWatch metric should be monitored to determine if the query is experiencing storage I/O bottlenecks?

A company is migrating an on-premises Oracle database to Amazon RDS for Oracle. The migration uses AWS DMS. After the migration, the database has a 30-minute recovery point objective (RPO). Which Amazon RDS feature should be configured to meet a 5-minute RPO?

A company is using Amazon RDS for MySQL and notices that the Read IOPS metric is consistently high during business hours. The application is read-heavy. Which configuration change would most likely reduce Read IOPS?

A developer reports that an application using Amazon DynamoDB is experiencing high latency during peak hours. The table has a provisioned capacity of 500 read capacity units (RCUs) and 500 write capacity units (WCUs). The application uses eventually consistent reads and the table is about 50 GB. The developer notices throttled write requests in CloudWatch. Which action would most effectively reduce write throttling?

A company is migrating an on-premises Oracle database to Amazon RDS for Oracle. During the migration, the database administrator notices that the CPU utilization on the RDS instance is consistently above 90% during peak hours, even though the on-premises server had similar specifications. The application queries are mostly SELECT statements with occasional DML. The RDS instance is db.r5.large with 500 GB of General Purpose SSD (gp2) storage. Which change would most likely reduce CPU utilization?

A team manages an Amazon Aurora MySQL database. They observe that the 'Deadlocks' metric in CloudWatch is spiking. The application uses a single writer instance and multiple read replicas. Which action is most effective at reducing deadlocks?

A database engineer is troubleshooting slow query performance on an Amazon RDS for PostgreSQL instance. The instance is db.r5.large with 500 GB of General Purpose SSD (gp2) storage. CloudWatch metrics show high Read Latency and high Read IOPS, but low CPU utilization. Which TWO actions should the engineer take to improve performance?

A company is using Amazon DynamoDB with autoscaling enabled. The table has a partition key of 'order_id' and a sort key of 'order_date'. The application performs both point queries and range queries. Recently, the 'ConsumedReadCapacityUnits' metric shows that the table is consistently using 100% of the provisioned capacity. Which THREE factors should the database engineer investigate to determine the cause?

A company is using Amazon RDS for MySQL and notices that database connections are being rejected intermittently. The application logs show 'Too many connections' errors. The DB instance has 1000 max_connections. Which action should the DBA take to troubleshoot and resolve this issue without impacting performance?

A database engineer is troubleshooting a production Amazon Aurora MySQL DB cluster. The application is experiencing high latency on write operations. The engineer checks the Amazon CloudWatch metrics and sees that the 'AuroraBinlogReplicaLag' metric is high. What is the most likely cause of the write latency?

A company is running a production Amazon DynamoDB table with on-demand capacity. The application is experiencing increased latency and throttled requests during peak hours. Which monitoring tool should the database specialist use to identify the specific partition keys causing the throttling?

Free account

Track your progress over time

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

Focused Monitoring and Troubleshooting sessions

Start a Monitoring and Troubleshooting only practice session

Every question in these sessions is drawn from the Monitoring and Troubleshooting domain — nothing else.

Related practice questions

Related DBS-C01 topic practice pages

Move into related areas when this topic feels solid.

Frequently asked questions

What does the DBS-C01 exam test about Monitoring and Troubleshooting?
Monitoring and Troubleshooting 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 Monitoring and Troubleshooting questions in a focused session?
Yes — the session launcher on this page draws every question from the Monitoring and Troubleshooting 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.