20+ practice questions focused on Management and Operations — one of the most tested topics on the AWS Certified Database Specialty DBS-C01 exam. Each question includes a detailed explanation so you learn why the right answer is correct.
Start Management and Operations PracticeA 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.)
Explanation: Gp2 storage uses a credit-based burst model, and the Burst Balance metric indicates the remaining I/O credits. If the burst balance is depleted, the instance is throttled to the baseline IOPS (3,000 for this size), causing high latency despite low CPU and adequate memory. Option E is also correct because monitoring Read/Write Latency metrics in CloudWatch directly measures storage performance and can confirm whether high latency is due to storage I/O issues. Together, these two metrics help identify if the gp2 burst credits are exhausted or if other storage-related latencies are occurring. Options B, C, and D are not the most appropriate first diagnostic steps: B suggests changing storage type without diagnosis, C does not directly address storage I/O, and D checks memory pressure, which is not indicated given adequate memory.
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.)
Explanation: Enabling Multi-AZ deployment for Amazon RDS for PostgreSQL provides automatic failover to a standby replica in a different Availability Zone. This reduces RTO by automating the DNS change and database promotion, typically completing within 60–120 seconds without manual intervention. Option C is correct because creating a read replica in a different Availability Zone allows you to manually promote it to a standalone instance during a failure, which can be faster than restoring from a backup, thereby reducing RTO. Although promotion is manual and takes a few minutes, it still offers a lower RTO compared to backup-based recovery. Option D, configuring automated backups with point-in-time recovery, primarily improves recovery point objective (RPO) rather than RTO, as restoring from a backup is typically slower and involves more steps. Options A and E do not directly reduce RTO since increasing instance class size does not aid failover, and manual snapshots also rely on restoration.
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?
Explanation: Increasing the instance size (Option A) provides more CPU and IO capacity to handle the write-heavy workload, thereby reducing CPU utilization. Read replicas (B) can offload read traffic but not write load. Multi-AZ (C) enhances availability but does not distribute writes; writes continue on the primary. ElastiCache (D) caches reads, not writes, so it does not reduce write-related CPU load.
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.)
Explanation: CPUUtilization (Option B) and FreeableMemory (Option A) are both default CloudWatch metrics for Amazon RDS. CPUUtilization measures the percentage of CPU capacity used by the database instance. FreeableMemory reports the amount of available random access memory. Both are automatically published to CloudWatch every minute without additional setup. DatabaseConnections (Option E) is also a default metric, but in the context of this question, the two correct answers are CPUUtilization and FreeableMemory. QueryThroughput (Option C) is not a standard CloudWatch metric for RDS; it is available from Performance Insights. ReadThrottleEvents (Option D) is not a default metric; it is specific to DynamoDB or RDS with provisioned IOPS. Therefore, the correct answers are A and B.
A database administrator runs the above CLI command. The DB instance has pending modifications. Which modification will take effect immediately without requiring a reboot?
Explanation: The `--apply-immediately` flag causes eligible modifications to be applied immediately. Both `BackupRetentionPeriod` and `MasterUserPassword` are parameters that can be changed dynamically without requiring a reboot. `BackupRetentionPeriod` adjusts the backup schedule in the background, and `MasterUserPassword` updates the password instantly via the RDS API. In contrast, `DBInstanceClass` and `AllocatedStorage` require a reboot even with `--apply-immediately`.
+15 more Management and Operations questions available
Practice all Management and Operations questions1. Baseline your knowledge
Start with 10 questions to gauge your current understanding of Management and Operations. This tells you whether you need a concept refresher or just practice.
2. Review every explanation
For each question — right or wrong — read the full explanation. Understanding why an answer is correct is more valuable than knowing the answer itself.
3. Focus on exam traps
Management and Operations questions on the DBS-C01 frequently use trap wording. Look for subtle differences in answers that test your precision, not just general knowledge.
4. Reach 80% consistently
Do repeated sessions until you score 80%+ three times in a row. Then move to mixed-mode practice to test cross-topic recall under realistic conditions.
The exact number varies per candidate. Management and Operations is tested as part of the AWS Certified Database Specialty DBS-C01 blueprint. Practicing with targeted Management and Operations questions ensures you can handle any format or difficulty that appears.
Yes. Courseiva provides free DBS-C01 practice questions across all exam topics and domains. The platform includes topic-based practice, mock exams, missed-question review, bookmarked questions, and readiness tracking — no account required.
Difficulty is subjective, but Management and Operations is a high-priority exam concept tested in multiple ways — direct recall, scenario analysis, and command-output interpretation. Consistent practice is the best way to build confidence.
Launch a full Management and Operations practice session with instant scoring and detailed explanations.
Start Management and Operations Practice →