Practice RDS Questions Now
Start a timed practice session focusing on Amazon Relational Database Service (RDS) topics from the SOA-C03 question bank.
Start SOA-C03 Practice Quiz →SOA-C03 RDS Question Bank (36 Questions)
Browse all 36 practice questions covering Amazon Relational Database Service (RDS) for the SOA-C03 certification exam. Answers are intentionally hidden on this page so you can self-test first before checking results in quiz mode.
- Question 1Reliability & Business Continuity
A SysOps administrator manages an RDS MySQL Multi-AZ deployment. During a planned maintenance window, the administrator needs to minimize downtime. The administrator wants to understand the failover behavior. Which statement accurately describes what happens during a Multi-AZ failover?
Answer hidden for practice.
Use the interactive quiz to reveal the correct answer and explanation.
Start SOA-C03 Quiz - Question 2Reliability and Business Continuity
A SysOps administrator is evaluating the recovery time for an RDS Aurora cluster. What is the typical automatic failover time for Aurora Multi-AZ?
Answer hidden for practice.
Use the interactive quiz to reveal the correct answer and explanation.
Start SOA-C03 Quiz - Question 3Reliability & Business Continuity
A company uses an Amazon Aurora MySQL Multi-AZ cluster with one writer and two reader instances. The writer instance fails, and Aurora initiates an automatic failover. How does Aurora handle the cluster endpoint during failover?
Answer hidden for practice.
Use the interactive quiz to reveal the correct answer and explanation.
Start SOA-C03 Quiz - Question 4Reliability & Business Continuity
A company requires a highly available MySQL database that provides two readable standby instances, automatic failover within approximately 35 seconds, and the ability to offload read traffic to the standby replicas. The database must remain on RDS (not Aurora). Which RDS deployment option meets these requirements?
Answer hidden for practice.
Use the interactive quiz to reveal the correct answer and explanation.
Start SOA-C03 Quiz - Question 5Reliability & Business Continuity
A company runs a Multi-AZ RDS PostgreSQL instance. The operations team wants to receive an email notification whenever a failover event occurs, so they can verify application connectivity. Which configuration provides automated failover notifications?
Answer hidden for practice.
Use the interactive quiz to reveal the correct answer and explanation.
Start SOA-C03 Quiz - Question 6Reliability & Business Continuity
A company runs a production MySQL database on Amazon RDS with a Multi-AZ deployment and a read replica in a different Region for disaster recovery. During a DR test, the team needs to promote the cross-Region read replica to a standalone database. What should the administrator understand about this promotion process?
Answer hidden for practice.
Use the interactive quiz to reveal the correct answer and explanation.
Start SOA-C03 Quiz - Question 7Reliability & Business Continuity
A SysOps administrator needs to test the failover of a Multi-AZ RDS PostgreSQL instance without affecting the application for more than a few seconds. What is the recommended approach?
Answer hidden for practice.
Use the interactive quiz to reveal the correct answer and explanation.
Start SOA-C03 Quiz - Question 8Select All That ApplyReliability & Business Continuity
A company wants to validate that their pilot light DR setup in us-west-2 can meet a 4-hour RTO. The pilot light environment has a cross-Region RDS read replica and AMIs copied to us-west-2 but no running EC2 instances. What should the administrator include in the failover test plan? (Select TWO.)
Answer hidden for practice.
Use the interactive quiz to reveal the correct answer and explanation.
Start SOA-C03 Quiz - Question 9Reliability & Business Continuity
A company operates a mission-critical application using an Amazon RDS for MySQL Multi-AZ DB instance in us-east-1. The disaster recovery requirement mandates an RPO of 1 hour and an RTO of 30 minutes with a failover target in us-west-2. Which architecture meets these requirements with the LEAST operational effort?
Answer hidden for practice.
Use the interactive quiz to reveal the correct answer and explanation.
Start SOA-C03 Quiz - Question 10Reliability and Business Continuity
A SysOps administrator uses Amazon RDS Multi-AZ for high availability. During a Multi-AZ failover, what happens to the DNS endpoint?
Answer hidden for practice.
Use the interactive quiz to reveal the correct answer and explanation.
Start SOA-C03 Quiz - Question 11Reliability and Business Continuity
A SysOps administrator wants to test the failover mechanism of an RDS Multi-AZ deployment. How can they initiate a failover without causing real downtime?
Answer hidden for practice.
Use the interactive quiz to reveal the correct answer and explanation.
Start SOA-C03 Quiz - Question 12Reliability and Business Continuity
A SysOps administrator wants to ensure that RDS snapshots are retained for 90 days. The default automated backup retention is capped at 35 days. What is the solution?
Answer hidden for practice.
Use the interactive quiz to reveal the correct answer and explanation.
Start SOA-C03 Quiz - Question 13Reliability & Business Continuity
An application uses Amazon Aurora MySQL with one writer and two reader instances across two Availability Zones. During a failover test, the application experienced 45 seconds of downtime because the connection string pointed to the writer instance endpoint. How should the administrator minimize failover impact?
Answer hidden for practice.
Use the interactive quiz to reveal the correct answer and explanation.
Start SOA-C03 Quiz - Question 14Reliability & Business Continuity
A SysOps administrator needs to create automated backups for Amazon EBS volumes attached to production EC2 instances. The backups must be retained for 30 days and older snapshots must be automatically deleted. Which solution meets these requirements with the LEAST operational overhead?
Answer hidden for practice.
Use the interactive quiz to reveal the correct answer and explanation.
Start SOA-C03 Quiz - Question 15Select All That ApplyReliability & Business Continuity
A company's Amazon Aurora MySQL cluster experienced a failover event. The application team reports that the application was unavailable for approximately 60 seconds during the failover. The application connects directly to the primary instance endpoint. What should the administrator change to reduce failover impact? (Select TWO)
Answer hidden for practice.
Use the interactive quiz to reveal the correct answer and explanation.
Start SOA-C03 Quiz - Question 16Select All That ApplyReliability & Business Continuity
A SysOps administrator needs to ensure an Aurora global database can failover from the primary Region (us-east-1) to a secondary Region (eu-west-1) with minimal data loss and downtime. (Select TWO.)
Answer hidden for practice.
Use the interactive quiz to reveal the correct answer and explanation.
Start SOA-C03 Quiz - Question 17Reliability & Business Continuity
A SysOps administrator is testing a disaster recovery scenario for an Aurora global database. During the unplanned failover simulation, the secondary Region is promoted, but the original primary Region comes back online with a split-brain scenario where both clusters accept writes. How should this be prevented?
Answer hidden for practice.
Use the interactive quiz to reveal the correct answer and explanation.
Start SOA-C03 Quiz - Question 18Reliability and Business Continuity
A SysOps administrator wants to implement a backup strategy where EBS snapshots are stored in a different AWS region automatically. Which service provides this?
Answer hidden for practice.
Use the interactive quiz to reveal the correct answer and explanation.
Start SOA-C03 Quiz - Question 19Reliability and Business Continuity
A SysOps administrator uses Aurora MySQL with Global Database. The primary region becomes completely unavailable. What is the process for regional failover?
Answer hidden for practice.
Use the interactive quiz to reveal the correct answer and explanation.
Start SOA-C03 Quiz - Question 20Networking and Content Delivery
A SysOps administrator uses AWS Direct Connect with a backup Site-to-Site VPN. Both are connected via a Virtual Private Gateway. How is failover achieved?
Answer hidden for practice.
Use the interactive quiz to reveal the correct answer and explanation.
Start SOA-C03 Quiz - Question 21Reliability & Business Continuity
A SysOps administrator needs to restore an RDS PostgreSQL instance to a specific point in time 3 hours ago. The instance has automated backups enabled with a 7-day retention period. What steps should the administrator take?
Answer hidden for practice.
Use the interactive quiz to reveal the correct answer and explanation.
Start SOA-C03 Quiz - Question 22Deployment, Provisioning & Automation
A CloudFormation template deploys resources for both production and development environments. In production, the template should create an RDS Multi-AZ deployment; in development, it should create a Single-AZ deployment. The environment type is passed as a parameter. Which CloudFormation feature implements this conditional logic?
Answer hidden for practice.
Use the interactive quiz to reveal the correct answer and explanation.
Start SOA-C03 Quiz - Question 23Monitoring, Logging & Remediation
A SysOps Administrator must ensure AWS Config continuously records configuration changes for all supported resources in a single AWS account. The Config delivery channel must deliver configuration snapshots every 6 hours to an S3 bucket and send change notifications to an SNS topic. After setup, the administrator notices that Config is not recording changes. Which is the MOST likely cause?
Answer hidden for practice.
Use the interactive quiz to reveal the correct answer and explanation.
Start SOA-C03 Quiz - Question 24Reliability & Business Continuity
A company with multiple accounts in an AWS Organization wants to enforce a consistent backup policy for all RDS databases and EBS volumes across every account. The backup policy should be managed centrally and automatically applied without manual configuration in each account. Which solution achieves this?
Answer hidden for practice.
Use the interactive quiz to reveal the correct answer and explanation.
Start SOA-C03 Quiz - Question 25Monitoring, Logging & Remediation
A SysOps administrator observes that an Amazon RDS MySQL instance has high CPU utilization. The administrator enables Performance Insights and identifies that a single query is consuming 90% of the database load. What should the administrator do NEXT to resolve the issue without modifying application code?
Answer hidden for practice.
Use the interactive quiz to reveal the correct answer and explanation.
Start SOA-C03 Quiz - Question 26Reliability & Business Continuity
A company runs a critical application on Amazon EC2 instances in a single Availability Zone. The application uses an Amazon RDS Multi-AZ DB instance. The company wants to improve the application tier availability. Which architecture change provides the highest availability with MINIMAL application changes?
Answer hidden for practice.
Use the interactive quiz to reveal the correct answer and explanation.
Start SOA-C03 Quiz - Question 27Reliability & Business Continuity
A SysOps administrator manages an ElastiCache for Redis cluster with cluster mode enabled across three shards. During failover testing, the administrator wants to understand the expected behavior when a primary node in one shard fails. Which statement is correct?
Answer hidden for practice.
Use the interactive quiz to reveal the correct answer and explanation.
Start SOA-C03 Quiz - Question 28Reliability & Business Continuity
A SysOps administrator configured AWS Backup to protect production RDS instances and EBS volumes. The compliance team requires that backups in the vault cannot be deleted by anyone — including administrators — for a minimum retention period of 365 days. How should the administrator configure this?
Answer hidden for practice.
Use the interactive quiz to reveal the correct answer and explanation.
Start SOA-C03 Quiz - Question 29Select All That ApplyReliability & Business Continuity
A company's production RDS MySQL database has five read replicas serving analytics queries. One read replica is experiencing significant replication lag exceeding 30 seconds. Which TWO actions should the administrator investigate? (Select TWO.)
Answer hidden for practice.
Use the interactive quiz to reveal the correct answer and explanation.
Start SOA-C03 Quiz - Question 30Reliability & Business Continuity
A company requires an RTO of 15 minutes and an RPO of 1 minute for their primary relational database. The database is currently a 2 TB Amazon RDS for PostgreSQL Multi-AZ instance in us-east-1. Which architecture satisfies both the RTO and RPO requirements?
Answer hidden for practice.
Use the interactive quiz to reveal the correct answer and explanation.
Start SOA-C03 Quiz - Question 31Reliability and Business Continuity
A SysOps administrator wants to ensure an RDS Aurora database can survive an AZ failure with zero RPO. Which Aurora feature provides this?
Answer hidden for practice.
Use the interactive quiz to reveal the correct answer and explanation.
Start SOA-C03 Quiz - Question 32Reliability and Business Continuity
A SysOps administrator wants to configure AWS Backup to protect all resources (RDS, EBS, DynamoDB, EFS) with a single backup plan. What determines which resources are included?
Answer hidden for practice.
Use the interactive quiz to reveal the correct answer and explanation.
Start SOA-C03 Quiz - Question 33Reliability and Business Continuity
A SysOps administrator uses RDS with automated backups. The default retention period is 7 days. The compliance team requires 35 days. How is this configured?
Answer hidden for practice.
Use the interactive quiz to reveal the correct answer and explanation.
Start SOA-C03 Quiz - Question 34Reliability and Business Continuity
A SysOps administrator configures an RDS instance with Multi-AZ. During normal operation, is read traffic sent to the standby instance?
Answer hidden for practice.
Use the interactive quiz to reveal the correct answer and explanation.
Start SOA-C03 Quiz - Question 35Reliability and Business Continuity
A SysOps administrator uses Amazon RDS with read replicas. A read replica falls behind the primary by 30 minutes. What metric indicates replication lag?
Answer hidden for practice.
Use the interactive quiz to reveal the correct answer and explanation.
Start SOA-C03 Quiz - Question 36Reliability and Business Continuity
A SysOps administrator wants to minimize the impact of planned AWS maintenance on RDS Multi-AZ instances. What action reduces impact?
Answer hidden for practice.
Use the interactive quiz to reveal the correct answer and explanation.
Start SOA-C03 Quiz
Key RDS Concepts for SOA-C03
SOA-C03 RDS Exam Tips
Amazon Relational Database Service (RDS) questions in SOA-C03 are typically scenario-based. Focus on operations, observability, incident response, and automated remediation. Priority concepts: rds, aurora, multi-az, read replica, snapshot, backup.
What SOA-C03 Expects
- Anchor your answer in prioritize operational visibility and repeatable runbook-ready automation.
- RDS scenarios for SOA-C03 are frequently mapped to Domain 1 (22%), Domain 2 (22%), Domain 4 (16%), Domain 5 (18%), so read the objective carefully before picking controls or architecture.
- Expect multi-topic scenarios where RDS interacts with IAM, networking, storage, or observability patterns rather than appearing as an isolated question.
- When two options are both technically valid, prefer the choice that best aligns with the exam's operational scope (Associate) and vendor best practices.
High-Value RDS Concepts
- Know the core RDS building blocks cold: rds, aurora, multi-az, read replica.
- Review the edge-case features and limits for snapshot, backup; these details are commonly used to differentiate answer choices.
- Practice service-integration reasoning: how RDS pairs with Backup & Recovery, VPC, CloudWatch in real deployment patterns.
- For SOA-C03, explain why the chosen RDS design meets reliability, security, and cost expectations better than the alternatives.
Common SOA-C03 Traps
- Watch for answers that deploy quickly but are hard to monitor or recover.
- Questions in Monitoring, Logging, Analysis, Remediation, and Performance Optimization often include distractors that look correct for RDS but violate least-privilege, durability, or availability requirements.
- Avoid picking options purely by feature name; validate data path, failure handling, and governance impact before answering.
- If the prompt hints at automation or repeatability, eliminate manual-only operational answers first.
Fast Review Checklist
- Can you compare at least two RDS implementation paths and justify which one best fits the scenario?
- Can you map the chosen answer back to Monitoring, Logging, Analysis, Remediation, and Performance Optimization (22%) outcomes for SOA-C03?
- Can you explain security and access boundaries for RDS without relying on default-open assumptions?
- Can you describe how RDS integrates with Backup & Recovery and VPC during failure, scaling, and monitoring events?