Easy ReviewSAA-C03
Design Secure Architectures82

RDS

Choose RDS failover, read replicas, recovery, storage growth, safe database updates, and connection pooling.

RDS availability, read scaling, backup recovery, and database updates use different mechanisms. These sections explain which copy serves reads, which copy can become a writer, and when recovery needs a new DB instance.

Managed vs self-managed databases

AWS offers managed services for relational databases, NoSQL databases and blockchain networks. Amazon RDS handles common administration tasks for relational databases, while RDS Custom allows access to the database environment and operating system.

How it works

  1. Choose a database type for the data: relational databases include Amazon RDS and Amazon Aurora; NoSQL databases include key-value, document and graph databases. Amazon RDS, NoSQL databases
  2. Use Amazon RDS Custom when a managed database needs customization of its database environment or operating system.
  3. Before customizing an RDS Custom for SQL Server host, pause automation for the change so monitoring and recovery do not interfere. Automation resumes when the pause ends.

Examples of database types:

Type Service
Relational Amazon RDS, Amazon Aurora
Key-value NoSQL Amazon DynamoDB
Document Amazon DocumentDB
Graph Amazon Neptune

Exam cues

  • If the question says key-value, document or graph database, think NoSQL: DynamoDB, DocumentDB or Neptune, respectively.
  • If the question says install an agent on a managed SQL Server host, think RDS Custom for SQL Server and pause automation before the change.
  • If the question says managed Hyperledger Fabric networks or Ethereum nodes, think Amazon Managed Blockchain.

Remember

  • NoSQL: DynamoDB, DocumentDB, Neptune. Relational: RDS, Aurora.
  • Amazon Managed Blockchain stopped accepting new customers on October 29, 2026; access ends after September 29, 2027.

Trap: Aurora is relational, while DynamoDB, DocumentDB and Neptune are NoSQL databases.

From the AWS docs (9)
  • Amazon RDS is a managed service that makes it easier to set up, operate and scale a relational database and manages common database administration tasks.
  • Amazon RDS Custom gives database administrators access to customize the database environment and operating system for legacy, custom and packaged applications, while automating administration tasks.
  • Key-value (DynamoDB), document (DocumentDB) and graph (Neptune) databases are NoSQL, non-relational databases.
  • Amazon Timestream is the purpose-built time series database; Timestream for LiveAnalytics is serverless with a memory store for recent data and a magnetic store for history, and Timestream for InfluxDB runs managed InfluxDB.
  • Amazon Timestream for LiveAnalytics closed to new customers on June 20, 2025; AWS points new workloads to Timestream for InfluxDB.
  • Amazon Managed Blockchain provides Ethereum and Bitcoin public nodes and private Hyperledger Fabric networks; it stopped accepting new customers on October 29, 2026, and existing customers lose access after September 29, 2027.
  • RDS Custom exists for Oracle and SQL Server and grants privileged access to the database and the host operating system.
  • Before customizing an RDS Custom host, pause RDS Custom automation for a set period so monitoring and instance recovery do not interfere; it resumes when the pause ends.
  • RDS instance usage is billed in one-second increments with a 10-minute minimum.

Database choices and costs

Amazon RDS manages common database tasks, so teams can run relational databases with less administration. Choosing between RDS and a database on Amazon EC2 depends on how much control the application needs.

How it works

  1. Choose RDS for a supported relational engine when you want AWS to handle installation, patching, backups, scaling and availability. The customer still optimizes the application.
  2. Consider EC2 when you need full control of the operating system or database software, or an engine RDS does not support. RDS Custom offers database and operating system customization while automating administration tasks.
  3. For a long-running RDS database, consider a reserved DB instance for a discount. For RDS for Oracle, choose License Included or Bring Your Own License (BYOL). Reserved DB instances, Oracle licensing

Exam cues

  • If the question says a MySQL database needs less patching and backup work, think RDS because it manages those tasks.
  • If the question says an existing Oracle license should be used, think RDS for Oracle BYOL because it offers that licensing model.
  • If the question says timestamped sensor readings, think Amazon Timestream for time series data. New customers should evaluate Timestream for InfluxDB because LiveAnalytics is closed to them. Timestream, availability change

Remember

  • RDS supports IBM Db2, MariaDB, Microsoft SQL Server, MySQL, Oracle Database and PostgreSQL.
  • Reserved DB instances offer one-year or three-year terms, with No Upfront, Partial Upfront or All Upfront payment.
  • Timestream for LiveAnalytics closed to new customers on June 20, 2025.

Trap: RDS manages database tasks, but the customer still optimizes the application.

From the AWS docs (9)
  • Amazon RDS manages backups, software patching, automatic failure detection and recovery, and offers high availability with a synchronous secondary instance and read replicas for read scaling.
  • On premises the customer manages everything; on Amazon EC2, AWS manages server maintenance, hardware lifecycle and power, network and cooling; with Amazon RDS, AWS also manages scaling, high availability, backups, database and OS patching and installation, while the customer still optimizes the application.
  • AWS recommends Amazon RDS as the default for most relational databases; running a database on EC2 means more time managing software and more risk of user error, for example when patching manually.
  • Amazon RDS Custom gives database administrators access to customize the database environment and operating system for legacy, custom and packaged applications, while automating administration tasks.
  • Amazon RDS supports IBM Db2, MariaDB, Microsoft SQL Server, MySQL, Oracle Database and PostgreSQL.
  • RDS reserved DB instances give a discount for a one-year or three-year term, with No Upfront, Partial Upfront or All Upfront payment.
  • RDS for Oracle offers two licensing models, License Included and Bring Your Own License (BYOL), and you can switch between them by modifying the DB instance.
  • Amazon Timestream is the purpose-built time series database; Timestream for LiveAnalytics is serverless with a memory store for recent data and a magnetic store for history, and Timestream for InfluxDB runs managed InfluxDB.
  • Amazon Timestream for LiveAnalytics closed to new customers on June 20, 2025; AWS points new workloads to Timestream for InfluxDB.

Multi-AZ and failover tests

Multi-AZ keeps database copies in separate Availability Zones (AZs), which are isolated locations within an AWS Region. It lets RDS move database service to another AZAn isolated location within an AWS Region used to separate database copies from a local failure. after an infrastructure failure. The RDS deployment models differ in whether their standby copies can serve reads.

How it works

  1. For a Multi-AZ DB instance, RDS maintains a synchronous standby: changes are copied as part of committing writes. The standby is in another AZ and does not accept application reads.
  2. A Multi-AZ DB cluster supports MySQL or PostgreSQL and has a writer and two readable replicas across three AZs. It uses semisynchronous replicationA replica acknowledges receiving a change before all replicas have applied it., where a replica acknowledges receipt before all replicas have applied the change.
  3. If a Multi-AZ DB instance suffers a qualifying outage, RDS promotes the standby and updates the database endpointA network name that clients use to connect to a database or proxy.’s DNSThe naming system that resolves a database endpoint name to its network address. record. DNS maps the endpoint name to an address. Clients must resolve the endpoint and reconnect.
  4. To add availability to an existing Single-AZ instance, modify it to enable Multi-AZ. RDS initializes standby storage from a snapshotA stored backup of the database instance storage at a particular time. and enables synchronous replicationChanges are copied to a standby as part of committing writes on the primary.. Allow for write-performance impact.
  5. Choose a DB subnet group to define the eligible VPC subnets for placement. RDS selects a subnet and an IP address from the group.
  6. For a Multi-AZ DB cluster, connect writes to the cluster writer endpoint and read-only work to the reader endpoint. These endpoints handle failoverDatabase service moves from a failed primary or writer to a standby or reader. better than an endpoint tied to one DB instance.

Exam cues

  • If the question says automatic recovery from an AZ failure, think Multi-AZ, because RDS manages a copy in another AZ and the failover.
  • If the question says reporting reads from a standby, think a Multi-AZ DB cluster or read replica, because the single standby of a Multi-AZ DB instance does not serve reads.
  • If the question says Java clients cannot reconnect after failover, think DNS cache settings, because an old cached address can hide the endpoint change.

Remember

  • Multi-AZ DB instance: one standby. Multi-AZ DB cluster: two readable replicas across three AZs.
  • DB instance failover typically takes 60 to 120 seconds; large transactions can extend it.
  • AWS recommends a Java DNS cache time-to-liveThe duration for which a cached DNS answer can be kept before it is looked up again. of no more than 60 seconds.
  • RDS for Oracle does not support Oracle Real Application Clusters (RAC). Use Multi-AZ for managed availability.

Trap: A readable replica and a single Multi-AZ standby have different roles. The single standby provides failover without serving application reads.

Multi-AZ DB instance connection and replication paths
SQL1synchronous2Applicationconnect by endpointPrimaryAZ A: reads and writesStandbyAZ B: no client reads
  1. The application connects to the primary through its database endpoint.

  2. RDS copies changes synchronously to the standby; after failover, the endpoint points to this standby and clients reconnect.

From the AWS docs (17)
  • A Multi-AZ DB instance synchronously copies changes to a standby in another Availability Zone.
  • The standby of a Multi-AZ DB instance cannot serve application reads.
  • A Multi-AZ DB cluster has a writer and two readable replicas in three Availability Zones in one Region.
  • A Multi-AZ DB cluster uses semisynchronous replication.
  • RDS automatically fails over a Multi-AZ DB instance to its standby after qualifying infrastructure outages.
  • Multi-AZ DB instance failover changes the endpoint DNS record to the standby and requires clients to re-establish connections.
  • Multi-AZ DB instance failover typically takes 60 to 120 seconds and can take longer with large transactions or recovery.
  • AWS recommends a Java DNS cache time-to-live no greater than 60 seconds for RDS failover.
  • An existing Single-AZ DB instance can be modified to Multi-AZ by adding a standby in another Availability Zone.
  • Single-AZ to Multi-AZ conversion creates standby volumes from a snapshot and enables synchronous replication; write performance can be affected.
  • Amazon RDS for Oracle does not support Oracle Real Application Clusters (RAC); AWS directs high-availability workloads to Multi-AZ.
  • An RDS DB instance needs a VPC with subnets in at least two Availability Zones, even for Single-AZ, so a standby can be created later.
  • Multi-AZ DB cluster failover typically completes in under 35 seconds, once both readers have applied the outstanding transactions of the failed writer.
  • An RDS DB subnet group lists eligible VPC subnets; RDS selects a subnet and an IP address from that group when placing a DB instance.
  • An RDS Multi-AZ DB cluster instance endpoint addresses one DB instance; writer and reader endpoints are better suited to connections that must follow failover.
  • The database engines available for an RDS Multi-AZ DB cluster are MySQL and PostgreSQL.
  • For an RDS Multi-AZ DB cluster, the cluster endpoint connects to the writer for reads and writes, while the reader endpoint sends read-only connections to reader instances.

Read replicas and Regional recovery

A read replica is a database copy used to move read queries away from an RDS source. Supported replicas can also provide a recovery copy in another Region. The RDS read-replica guide explains that replication is asynchronous: the source can commit a write before the replica receives it.

How it works

  1. Enable backup retention on the source, then create a supported read replica. RDS initializes the copy and uses the engine’s replication mechanism to send changes.
  2. Send reporting or other supported read workloads to the replica. Watch ReplicaLag, the delay in seconds behind the source; recent writes might not yet be visible.
  3. For Regional recovery, create the replica in another Region before an outage. A supported replica can also have its own Multi-AZ standby, independent of the source’s configuration.
  4. When recovery requires a new writable database, promote the replica. RDS reboots it and ends replication from the old source. Redirect the application and create a replacement replica.
  5. For a MySQL replica stopped by a packet size error, match max_allowed_packet in the source and replica parameter groups.

Exam cues

  • If the question says reporting queries overload the source, think read replicas, because they move read work to separate database instances.
  • If the question says recover in another Region with a running database copy, think cross-Region read replica promotionA read replica becomes a standalone database and stops replicating from its original source., because the replica can become standalone. Account for recent writes that have not replicated.
  • If the question says the reporting replica also needs AZAn isolated location within an AWS Region used to separate database copies from a local failure. failoverDatabase service moves from a failed primary or writer to a standby or reader., think Multi-AZ for that replica, because it can have its own standby.
  • If RDS for MySQL replication stops on a packet size error, compare max_allowed_packet on source and replica.

Remember

  • Add and remove RDS DB instance read replicas manually; their count does not autoscale with read demand.
  • Promotion can take several minutes or longer and stops replication from the source.
  • Same-Region replication transfer is free. Cross-Region initial snapshotA stored backup of the database instance storage at a particular time. transfer and ongoing change transfer are billed.
  • Replica instances have their own standard DB instance charges.

Trap: A cross-Region read replica is not a guarantee that every committed write survives a source outage. Asynchronous replicationA source can commit a database change before a replica receives and applies it. can leave the recovery copy behind.

Cross-Region replica before and after promotion
12Source databaseRegion ARead replicaRegion B: before recoveryStandalone DBRegion B: after promotion
  1. Changes flow from the source to the cross-Region replica and can lag.

  2. Promotion reboots the replica and ends source replication; redirect application traffic to the standalone database.

From the AWS docs (13)
  • RDS read replicas use asynchronous engine replication to offload supported read workloads from the source.
  • Asynchronous RDS replication can return stale data; ReplicaLag measures delay behind the source in seconds for supported engines.
  • RDS DB instance read replicas must be created and removed manually rather than automatically scaled with read demand.
  • The source of an RDS read replica must have backup retention enabled.
  • Supported RDS DB instance read replicas can reside in a different Region from the source.
  • Promoting an RDS read replica makes it a standalone DB instance and stops its replication relationship with the source.
  • For recovery using a read replica, promote it, redirect database traffic to it, and create a replacement replica.
  • Read replica promotion reboots the instance and can take several minutes or longer.
  • A supported RDS read replica can have its own Multi-AZ standby regardless of the source deployment type.
  • RDS does not charge for replication data transfer to a read replica within the same Region.
  • Cross-Region read replica transfer charges apply to the initial snapshot and ongoing changes leaving the source Region.
  • RDS read replicas are billed as standard DB instances for their instance class.
  • RDS for MySQL replication can stop if the replica's max_allowed_packet is smaller than the source's; use matching values in their parameter groups to resolve this error.

Backups and point-in-time recovery

RDS backups provide earlier copies of a database for recovery after a data error. Point-in-time recoveryRestoration creates a new database instance at an available time within the backup retention window. (PITR) combines backups and transaction logsA record of database changes used with backups for point-in-time recovery., which record database changes, to recover to an available time within the retention window. The backup guide describes backups of the whole DB instance.

How it works

  1. Set automated backup retention. A value of 0 disables automated backups for a DB instance; changing between 0 and a nonzero value causes an outage.
  2. RDS stores automated backups and manual DB snapshotsA stored backup of the database instance storage at a particular time. in Amazon S3, and uploads transaction logs every five minutes. Check LatestRestorableTime before selecting a recovery point.
  3. Use PITR to restore to an available time before the error. RDS creates a new DB instance and leaves the source unchanged.
  4. Preserve a manual or final snapshot when deleting an instance if you need a lasting recovery copy. Automated backups require an explicit retain choice to survive deletion for their retention period.
  5. For supported DB instances, cross-Region automated backup replication copies snapshots and transaction logs to a destination Region. Multi-AZ DB clusters do not support this feature.
  6. A snapshot restore can be available before all data has loaded from Amazon S3. Include this background loading and its effect on queries when assessing recovery readiness.

Exam cues

  • If the question says an accidental deletion has reached the Multi-AZ standby, think PITR before the deletion, because synchronous replicationChanges are copied to a standby as part of committing writes on the primary. also copies unwanted changes.
  • If the question says recover a deleted DB instance after its automated backups are gone, think a retained manual or final snapshot, because those copies are independent of instance deletion.
  • If the question says restore without overwriting the source, think PITR, because it creates another DB instance.

Remember

  • DB instance retention: 0 to 35 days. Multi-AZ DB cluster retention: 1 to 35 days.
  • New DB instance defaults: one day through API/CLI, seven days through the console.
  • Transaction log upload interval: five minutes. Use the actual LatestRestorableTime for recovery.
  • Automated backups and manual DB snapshots cover DB instance storage, rather than a selected table or database.

Trap: Multi-AZ availability does not supply an earlier database state. A committed mistake is copied to the standby; restore a backup from before the mistake.

From the AWS docs (20)
  • RDS backups and manual DB snapshots cover the DB instance storage, rather than only a selected database.
  • RDS point-in-time recovery restores a DB instance to an available time within its backup retention period.
  • RDS point-in-time recovery creates a new DB instance without changing the source.
  • RDS uploads DB instance transaction logs to Amazon S3 every five minutes.
  • LatestRestorableTime reports the latest available recovery time for an RDS DB instance.
  • An RDS DB instance backup retention period can be 0 to 35 days; 0 disables automated backups.
  • For a newly created RDS DB instance, backup retention defaults to one day through the API or CLI and seven days through the console.
  • A Multi-AZ DB cluster backup retention period can be 1 to 35 days.
  • Changing RDS DB instance backup retention between 0 and a nonzero value causes an outage.
  • Manual and final RDS snapshots survive deletion of the DB instance independently of automated backups.
  • Deleting an RDS DB instance deletes automated backups unless the user chooses to retain them for the retention period.
  • Supported RDS DB instances can replicate snapshots and transaction logs to another Region; this automated backup replication is not supported for Multi-AZ DB clusters.
  • RDS Multi-AZ DB instance replication copies database changes synchronously to the standby.
  • RDS includes free backup storage up to 100 percent of the total provisioned database storage in the account for each Region, covering DB snapshots and DB cluster snapshots.
  • Aurora automated backups cannot be turned off; the cluster keeps continuous, incremental backups for its retention period (1 day by default).
  • RDS for MySQL can create a new DB instance from backup files that you upload to Amazon S3.
  • The first snapshot of a DB instance holds the full database; later snapshots of it store only the data changed since the most recent snapshot.
  • Final and manual DB snapshots are kept after the DB instance is deleted, independent of the backup retention period; automated backups are deleted with the instance unless you choose to retain them.
  • An RDS snapshot restore can become available while data still loads in the background; accessing data not yet loaded downloads it from Amazon S3.
  • Automated RDS backups and manually created DB snapshots use Amazon S3 for backup storage.

Storage autoscaling and metrics

RDS storage autoscaling grows a DB instance’s allocated disk space when free space stays low. It addresses storage capacity up to a configured ceiling. CloudWatch metrics separately show disk queues, operation times, CPU use, and connections.

How it works

  1. Enable autoscaling and set a maximum storage threshold. It must be at least 10 percent above current allocation; AWS recommends 26 percent or more. Changing this setting does not require downtime.
  2. Monitor the remaining space and I/ODisk read and write operations performed for a database., meaning disk reads and writes. A large load can still fill storage before another modification is permitted. Autoscaling never shrinks allocated storage.
  3. Use Enhanced Monitoring to see real-time CPU and memory use by database and operating system processes. Use CloudWatch Database Insights to examine database load by waits, SQL statements, hosts, or users.
  4. For a database that requires predictable I/O performance and consistently low latency, choose Provisioned IOPSThe number of disk read or write operations completed each second. SSD storage. Storage autoscaling addresses capacity growth separately.

Exam cues

  • If the question says unpredictable disk growth, think storage autoscaling with a suitable maximum, because RDS can increase allocation when its low-space conditions are met.
  • If the question says rising disk queues and slow queries, think queue, latency, IOPS, and throughputThe number of bytes read from or written to disk per second. metrics together, because they describe different parts of disk activity. IOPS means operations per second; throughput means bytes transferred per second.
  • If the question says CPU and memory use by process, think Enhanced Monitoring, because its process list reports both.
  • If the question says identify SQL statements behind database load, think CloudWatch Database Insights, because it can filter load by SQL statement.

Remember

Metric Meaning
DiskQueueDepth Read/write requests waiting for disk access
ReadLatency, WriteLatency Average seconds per disk operation
ReadIOPS, WriteIOPS Disk operations per second
ReadThroughput, WriteThroughput Bytes read or written per second
FreeStorageSpace Available storage in bytes
CPUUtilization CPU use as a percentage
DatabaseConnections Client network connections, excluding some internal sessions
ReplicaLag Supported replica delay in seconds

Trap: Storage autoscaling cannot guarantee that a large import avoids a full disk. Storage can fill before another modification is permitted, and growth stops at the configured ceiling.

From the AWS docs (17)
  • RDS storage autoscaling automatically increases allocated storage up to a configured maximum threshold.
  • The RDS autoscaling maximum threshold must be at least 10 percent above current allocated storage; AWS recommends at least 26 percent above it.
  • Storage autoscaling cannot reduce RDS allocated storage.
  • Large data loads can fill RDS storage before another autoscaling modification is permitted.
  • Enabling or changing RDS storage autoscaling settings does not require a reboot or downtime.
  • DiskQueueDepth counts outstanding disk read and write requests waiting for access.
  • ReadLatency and WriteLatency measure average time per disk I/O operation in seconds.
  • ReadIOPS and WriteIOPS measure disk operations per second; ReadThroughput and WriteThroughput measure bytes per second.
  • FreeStorageSpace measures available RDS storage in bytes.
  • DatabaseConnections counts client network connections; it does not include every internal database session.
  • CPUUtilization measures the percentage of CPU used by the DB instance.
  • ReplicaLag measures supported RDS read replica delay in seconds.
  • RDS DB instance read replicas do not automatically scale their count with read demand.
  • Enhanced Monitoring reads operating system metrics in real time from an agent on the DB instance, while standard CloudWatch metrics come from the hypervisor, and delivers them to CloudWatch Logs (log group RDSOSMetrics, 30 days by default).
  • The Enhanced Monitoring process list shows RDS child processes (such as mysqld), RDS processes and OS processes, with the memory and CPU each one uses.
  • CloudWatch Database Insights, which builds on Performance Insights, shows database load and filters it by waits, SQL statements, hosts or users, so you can find the queries that load the database.
  • Amazon RDS Provisioned IOPS SSD storage suits databases that need consistently low I/O latency and predictable I/O performance.

RDS Proxy connection pooling

RDS Proxy reduces connection pressure by keeping a shared pool of database connections. A connection poolA set of open database connections shared and reused across client requests. is a set of open connections that clients can reuse. The RDS Proxy guide describes reuse, authentication, and recovery through a standby after database failure.

How it works

  1. Point application clients at the proxy endpointA network name that clients use to connect to a database or proxy., the connection address for the proxy. Client connections end there; RDS Proxy manages separate connections to the database.
  2. The proxy shares backend connections among client requests. It can enforce IAM authentication, which uses AWS identities, and connect to the database using IAM authentication or credentials from Secrets Manager.
  3. Under overload, the proxy can queue or throttle requests and reject client connections when configured limits are exceeded.
  4. Watch for session pinningA client session keeps one backend database connection until that session ends., where a client keeps one backend connection until its session ends. This reduces sharing. For repeated reads that tolerate stale results, ElastiCache query caching can reduce database work: a miss queries the database and stores the result.
  5. Check engine and version eligibility: RDS Proxy supports RDS MariaDB, MySQL, PostgreSQL and SQL Server, and Aurora MySQL and PostgreSQL. AWS manages and scales the proxy capacity.
  6. Require TLS/SSL in the client connection settings to encrypt the connection to the proxy. The client-to-proxy TLS version can differ from the version used with the database.

Exam cues

  • If the question says bursts of short Lambda invocations exhaust RDS connections, think RDS Proxy, because it reuses connections across client requests.
  • If the question says repeated read queries consume database CPU, think query caching when stale results are acceptable, because a cache hit avoids another database query.

Remember

  • Session pinning ties one backend connection to a client session until it ends.
  • The proxy can queue or throttle requests and reject connections when configured limits are exceeded.

Trap: A proxy shares connections but still has capacity limits. It can reject demand, and pinning can reduce reuse. Query caching also needs a consistency decision: avoid it for reads that must always reflect the latest write.

Client connections and shared database connections
connect1reuse pool2Applicationmany short connectionsRDS Proxyshared backend poolDatabasebounded connections
  1. Application connections terminate at the proxy endpoint.

  2. The proxy shares database connections up to its configured limit; session pinning reduces sharing.

From the AWS docs (12)
  • RDS Proxy shares and reuses database connections to reduce the overhead of opening connections for each client request.
  • RDS Proxy can enforce IAM authentication for clients and use IAM database authentication or Secrets Manager credentials for database connections.
  • RDS Proxy can connect to a standby during database failure while preserving application connections.
  • Clients connect to RDS Proxy, while the proxy manages separate database connections.
  • RDS Proxy session pinning reserves one underlying database connection for a client session until that session ends, reducing reuse.
  • RDS Proxy can queue or throttle requests and reject client connections when configured limits are exceeded.
  • Caching repeated relational query results in ElastiCache reduces repeated database reads; a cache miss queries the database and stores the result.
  • Query caching is unsuitable when queries require strong consistency or read-after-write consistency inside multi-statement transactions.
  • A proxy default endpoint is provisioned across two Availability Zones chosen from its subnets; up to 20 additional endpoints can be added per proxy.
  • RDS Proxy supports eligible versions of RDS for MariaDB, MySQL, PostgreSQL and SQL Server, plus Aurora MySQL and Aurora PostgreSQL.
  • RDS Proxy is fully managed and automatically scales its capacity with application demand.
  • Clients can require TLS/SSL when connecting to an RDS Proxy endpoint; the proxy can accept a newer TLS version than its underlying database.

Encryption, authentication and maintenance

RDS security includes encryption at rest and SSL/TLS encryption for connections. Maintenance behavior on Multi-AZ is another common exam topic.

How it works

  1. Choose encryption and a KMS key when creating the instance.
  2. To fix an unencrypted instance: snapshotA stored backup of the database instance storage at a particular time., encrypted copy, restore (or blue/green).
  3. To share an encrypted snapshot: it must use a customer managed key shared with the target account.
  4. Clients use SSL/TLS to encrypt connections in transit.
Maintenance on Multi-AZ Effect
Operating system update Standby first, then failoverDatabase service moves from a failed primary or writer to a standby or reader., then old primary: short interruption
Database engine upgrade Primary and standby together: downtime until done

Exam cues

  • If the question says encrypt an existing unencrypted RDS database, think encrypted snapshot copy and restore.
  • If the question says share an encrypted snapshot across accounts, think a customer managed key.
  • If the question says encrypt connections to an RDS database, think SSL/TLS.

Remember

  • Encryption at rest is set at creation; the KMS key can’t change later.
  • Default-key snapshots can’t be shared; encrypted snapshots can’t be public.

Trap: Multi-AZ protects against OS patching and instance failure, not engine upgrades. An engine version upgrade still causes downtime.

From the AWS docs (15)
  • Amazon RDS encrypts DB instances at rest with an AWS KMS key, either the AWS managed key for RDS (the default) or a customer managed key you choose when creating the instance.
  • To encrypt an unencrypted RDS DB instance or change its KMS key, copy a manual snapshot with encryption enabled and restore it, or use a blue/green deployment with an encrypted green environment.
  • Once an encrypted RDS DB instance exists, you can't change the KMS key it uses.
  • An RDS snapshot encrypted with the account's default AWS managed key can't be shared; copy it with a customer managed key, share that copy, and give the target account access to the key.
  • Encrypted RDS snapshots can't be shared publicly.
  • SSL/TLS connections encrypt data moving between a client and an RDS DB instance and can verify the server's identity with its certificate.
  • In a Multi-AZ deployment, RDS applies operating system updates to the standby first, promotes it to primary, then updates the old primary, which becomes the new standby.
  • A database engine upgrade on a Multi-AZ RDS instance modifies the primary and standby at the same time, so the database is unavailable until the upgrade finishes.
  • To require encrypted connections, set rds.force_ssl to 1 for RDS for SQL Server (a static parameter, so reboot) or require_secure_transport to ON for RDS for MySQL (no reboot needed) in the DB parameter group.
  • A read replica has the same encryption state as its source: an unencrypted instance cannot have an encrypted replica, and an encrypted one cannot have an unencrypted replica.
  • RDS can publish database logs, such as the MySQL audit, error, general and slow query logs, to CloudWatch Logs, where they are kept until a retention period is set.
  • RDS major version upgrades are always started manually; minor version upgrades can be applied manually or automatically by turning on Auto minor version upgrade.
  • RDS for Oracle and RDS for SQL Server also support Transparent Data Encryption (TDE), an engine feature with its own keys that can run alongside RDS encryption at rest.
  • KMS keys belong to one Region, so copying an encrypted DB snapshot or creating an encrypted read replica in another Region requires a KMS key in the destination Region.
  • RDS encryption at rest covers the DB instance storage plus its logs, automated backups, read replicas and snapshots.

RDS design choices and limits

RDS design choices affect database access, availability and operations. These details help you choose how clients connect and what to expect from backups, failoverDatabase service moves from a failed primary or writer to a standby or reader. and stopped instances.

How it works

  1. A Multi-AZ DB instance uses a synchronous standby. Automated backups can still cause elevated latency; Multi-AZ does not guarantee a backup window without performance impact. RDS Custom for Oracle and SQL Server also support a synchronous standby in another Availability ZoneAn isolated location within an AWS Region used to separate database copies from a local failure., but require prerequisites.
  2. For MariaDB, MySQL and PostgreSQL, IAM database authentication lets clients use a short-lived token instead of a password.
  3. Every DB instance has a private IP address in its VPC, a private virtual network. To make an instance publicly accessible, every subnet in its DB subnet group must be public, and the VPC must have DNSThe naming system that resolves a database endpoint name to its network address. hostnames and DNS resolution enabled. See working with a DB instance in a VPC.
  4. RDS Proxy must be in the database’s VPC and cannot be public. During failover, most client connections remain open, but connections in the middle of a transaction or SQL statement are canceled. The proxy accepts new connections immediately.
  5. A stopped DB instance starts automatically after its maximum stop period, so it does not miss required maintenance.
  6. For data modeling, relational tables store records as rows and attributes as columns. Row layouts suit transactions that touch complete records. Key-value access suits looking up a value by its key.
  7. A DB instance can host multiple logical databases, depending on its engine. Estimate instance compute, provisioned storage and any provisioned IOPSThe number of disk read or write operations completed each second. separately.
  8. An eligible instance can change VPCs through a destination DB subnet group, after resolving Multi-AZ and replica restrictions.

Exam cues

  • If the question says avoid storing a database password for a PostgreSQL client, think IAM database authentication, because it uses a token.
  • If the question says public access is enabled but the DB subnet group contains private subnets, think subnet configuration, because every subnet in the group must be public.
  • If the question says RDS Custom needs a standby, think Multi-AZ and its prerequisites, because RDS Custom runs inside your account.
  • If the question says a proxy client was executing a transaction during failover, think canceled connection, because in-flight work is interrupted.
  • If the question says a test instance should remain stopped indefinitely, think automatic restart, because RDS limits the stop period.

Remember

  • IAM authentication tokens last 15 minutes.
  • A DB instance can remain stopped for at most 7 consecutive days.
  • RDS for MySQL supports up to 15 read replicas per source DB instance in the same Region.
  • RDS Custom for Oracle support ends March 31, 2027; its console and resources cannot be accessed afterward.
  • IAM database authentication decides who connects; database privileges decide what that user can do.

Trap: Public access on a DB instance does not make RDS Proxy public. The proxy remains private even when its database is publicly accessible.

From the AWS docs (16)
  • RDS Multi-AZ deployments can still experience elevated latency during automated backups; Multi-AZ is not a guarantee of a backup window without performance impact.
  • IAM database authentication works with RDS for MariaDB, MySQL and PostgreSQL; clients connect with an authentication token that lasts 15 minutes instead of a password.
  • Every DB instance has a private IP address in its VPC. To make it publicly accessible, every subnet in its DB subnet group must be public and the VPC needs DNS hostnames and DNS resolution turned on.
  • RDS Custom for Oracle and RDS Custom for SQL Server support Multi-AZ deployments with a synchronous standby in another AZ; unlike regular RDS Multi-AZ, they need prerequisites set up first because RDS Custom runs inside your account.
  • AWS will end support for RDS Custom for Oracle on March 31, 2027, after which its console and resources can no longer be accessed (noted November 2026).
  • An RDS DB instance can be stopped for at most 7 consecutive days; after that RDS starts it automatically so it does not miss required maintenance.
  • RDS Proxy must be in the same VPC as the database and cannot be publicly accessible, even when the database is.
  • During a failover, most client connections through RDS Proxy stay open; only connections in the middle of a transaction or SQL statement are canceled, and the proxy accepts new connections immediately.
  • RDS for MySQL supports up to 15 read replicas per source DB instance in the same Region.
  • Row-based data layouts suit transactional access that reads or changes complete records; columnar layouts suit analytical queries that scan selected columns.
  • An eligible RDS DB instance can move to another VPC by selecting a DB subnet group in the destination VPC; Multi-AZ instances and instances with read-replica relationships must first have those restrictions resolved.
  • A relational database organizes records in table rows and their attributes in columns.
  • A key-value database associates a value with a unique key, and applications can retrieve the associated data by that key.
  • A single RDS DB instance can serve more than one logical database when its engine allows it.
  • Amazon RDS pricing includes DB instance compute capacity and provisioned storage; Provisioned IOPS storage also charges for the IOPS provisioned.
  • IAM database authentication controls who can connect as a database user; the privileges granted to that user inside the database still control what it can do.

Flashcards

tap to flip
Answer

·

All 82 cards as a list

Which of these AWS databases are NoSQL: Amazon DynamoDB, Amazon Neptune, Amazon DocumentDB, Amazon Aurora?

DynamoDB (key-value), Neptune (graph) and DocumentDB (document). Aurora is relational.

Which managed AWS service helps a company run a relational database without handling routine database administration?

Amazon RDS. It helps set up, operate and scale relational databases and manages common administration tasks.

A company needs a managed relational database but also needs to customize its operating system for a legacy application. Which Amazon RDS option fits?

Amazon RDS Custom provides access to customize the database environment and operating system while automating administration tasks.

What does Amazon RDS manage that a database on Amazon EC2 leaves to the customer?

Database and OS installation and patching, backups, scaling, high availability, and failure detection and recovery.

A team wants a relational MySQL database without patching or backing it up themselves. Should they run it on EC2 or Amazon RDS?

Amazon RDS, which AWS recommends as the default for relational databases.

When does running a database yourself on Amazon EC2 make sense instead of Amazon RDS?

When you need full control of the operating system or database software, or an engine RDS doesn't support. RDS Custom is the managed option when you need OS access for some engines.

Which database engines does Amazon RDS support (besides Aurora)?

IBM Db2, MariaDB, Microsoft SQL Server, MySQL, Oracle Database and PostgreSQL.

With Amazon RDS, does AWS optimize the customer's application queries?

No. Application optimization stays with the customer on premises, on EC2 and on RDS.

A company runs an Amazon RDS database around the clock for the next three years. How can it lower the instance cost?

Buy RDS reserved DB instances for a three-year term (No, Partial or All Upfront).

An RDS production database will run for years. How can its instance cost drop?

Buy RDS reserved DB instances for a one- or three-year term. They are a billing discount applied to matching DB instances.

Which RDS engine lets a company bring its own existing database licenses?

RDS for Oracle, which offers Bring Your Own License as well as License Included.

A company needs a managed relational database that supports PostgreSQL. Which AWS service can it choose?

Amazon RDS supports PostgreSQL and manages tasks such as backups and software patching.

An RDS application needs automatic recovery if its database Availability Zone fails. Which deployment should the team choose?

A Multi-AZ DB instance. RDS maintains a synchronous standby in another Availability Zone and automatically fails over after qualifying outages.

Can the standby of an RDS Multi-AZ DB instance serve reporting queries?

No. Use a read replica or a Multi-AZ DB cluster with readable replicas. The single standby is reserved for failover.

An RDS Multi-AZ DB instance has failed over, but the application still uses an old connection. What must the application do?

Resolve the database endpoint again and reconnect. RDS updates its DNS record, but existing connections must be re-established.

Must a team recreate an existing Single-AZ RDS DB instance to obtain a Multi-AZ standby?

No. Modify the existing instance to enable Multi-AZ. Plan for possible write-performance impact while the standby is initialized.

An RDS for Oracle migration requires Oracle RAC for availability. Is that feature supported?

No. RDS for Oracle does not support Oracle RAC. Use RDS Multi-AZ for the managed standby and failover requirement.

An RDS for PostgreSQL workload needs faster failover than the 60 to 120 seconds of a Multi-AZ DB instance, plus readable standbys. Which RDS deployment fits?

A Multi-AZ DB cluster: a writer and two readable replicas in three AZs. Failover is typically under 35 seconds.

When creating an Amazon RDS DB instance in a VPC, what controls which subnets RDS can choose for placement?

The DB subnet group. It lists eligible VPC subnets from which RDS selects a subnet and IP address.

An Amazon RDS Multi-AZ DB cluster application uses an individual instance endpoint for writes. Which endpoint better supports reconnecting after writer failover?

The cluster writer endpoint. It tracks the current writer; an instance endpoint identifies a particular DB instance.

A team choosing Amazon RDS needs a Multi-AZ DB cluster with readable replicas. Which database engines can it select?

MySQL or PostgreSQL. RDS Multi-AZ DB clusters support these two engines.

An Amazon RDS Multi-AZ DB cluster serves order updates and read-only reports. Which endpoints should the application use?

The cluster writer endpoint for updates and the reader endpoint for reports. The reader endpoint creates read-only connections to reader instances.

How do RDS DB instance read replicas scale reads, and what happens when one is promoted?

They receive changes asynchronously and can return stale data. Add or remove replicas manually. Promotion creates a standalone database and ends replication from the source.

An RDS source Region is unavailable and a cross-Region read replica exists. What recovery steps and costs should the team expect?

Promote the replica, redirect database traffic, and establish a replacement replica. Asynchronous replication can leave recent writes missing. Cross-Region snapshot and change transfer incur charges.

An RDS reporting replica must survive an Availability Zone failure without promoting it away from its source. What should the team configure?

A Multi-AZ deployment for the supported read replica. Its own standby provides failover support independently of the source deployment.

How does RDS read-replica replication pricing differ within one Region and across Regions?

Same-Region replication transfer has no charge. Cross-Region transfer of the initial snapshot and ongoing changes is billed. Replica instance charges still apply.

An RDS team has disabled automated backups on a source DB instance and wants a read replica. What must change first?

Enable backup retention on the source. The read-replica creation API requires it.

Does promoting an RDS read replica provide an instant, reversible role change?

No. Promotion reboots the replica and ends its replication relationship with the source. Plan traffic redirection and a replacement replica.

A company needs a regional disaster recovery option for an RDS database. How can a cross-Region read replica help?

Promote the replica if the source Region is unavailable, then redirect database traffic. Asynchronous replication can leave recent writes missing.

An accidental table deletion is committed on an RDS Multi-AZ DB instance. Is failover sufficient to recover the earlier data?

No. The deletion is copied to the standby. Use point-in-time recovery to create a new DB instance from an available time before the deletion.

What are the automated backup retention defaults for a newly created RDS DB instance?

One day through the API or CLI; seven days through the console. DB instance retention can be 0 to 35 days, with 0 disabling automated backups.

An RDS team wants to restore to the current second after an incident. Which value must it check first?

LatestRestorableTime. RDS uploads transaction logs every five minutes, so the latest available recovery point can lag the current time. Recovery creates a new instance.

An RDS DB instance is about to be deleted, but a team needs a recovery copy afterwards. Which backups should it preserve?

Create or keep a manual or final snapshot. These survive instance deletion. Explicitly retain automated backups if their recovery window is also needed.

Can an RDS Multi-AZ DB cluster use the same native cross-Region automated backup replication feature as a supported RDS DB instance?

No. That feature replicates DB instance snapshots and transaction logs, but does not support Multi-AZ DB clusters.

A team needs to choose an RDS backup retention period for point-in-time recovery. What determines the available recovery window?

The backup retention period. Point-in-time recovery restores an instance to an available time within that period.

Can you set the backup retention of an Aurora cluster to 0 to turn automated backups off?

No. Aurora automated backups cannot be disabled; only RDS DB instances can set retention to 0.

A team needs to recover an RDS DB instance after an accidental change. What does point-in-time recovery create?

A new DB instance restored to an available time within the backup retention period. The source is unchanged.

A team deletes an RDS DB instance without choosing to retain automated backups. What happens to its automated backups and to its manual DB snapshots?

Automated backups are deleted with the instance. Manual and final snapshots are kept until you delete them.

An Amazon RDS snapshot restore is available, but queries touching some data are slow. What recovery behavior should the team account for?

Lazy loading. Data continues loading from Amazon S3 after the instance becomes available, and access to unloaded data triggers a download.

Which AWS storage service holds Amazon RDS automated backups and manual DB snapshots?

Amazon S3. RDS uses it for backup storage.

An Amazon RDS DB instance hosts several databases. Can a manual DB snapshot back up only one selected database?

No. A DB snapshot covers the DB instance storage, including its databases.

An RDS DB instance is slow while disk requests accumulate. Which CloudWatch metrics distinguish queued work from storage service time and rate?

Compare DiskQueueDepth with ReadLatency and WriteLatency, ReadIOPS and WriteIOPS, and ReadThroughput and WriteThroughput. They measure queued requests, operation duration, operation rate, and byte rate.

An RDS DB instance repeatedly runs low on disk space. What feature can grow its allocated storage?

Enable storage autoscaling with a maximum threshold at least 10 percent above allocated storage. It grows storage up to that limit and cannot shrink it.

Which RDS CloudWatch metrics show CPU pressure, free disk space, client connection count, and supported replica delay?

CPUUtilization, FreeStorageSpace, DatabaseConnections, and ReplicaLag, respectively. FreeStorageSpace is in bytes and ReplicaLag is in seconds.

A large RDS data import fills the disk even though storage autoscaling is enabled. Can autoscaling guarantee the import will finish?

No. A large load can outpace permitted storage modifications. Allocate enough storage before the load and check the maximum threshold.

An RDS team needs to see how much CPU and memory each database process uses, in real time. Standard CloudWatch metrics are not enough. What should they turn on?

Enhanced Monitoring. Its agent on the DB instance reports OS metrics and a process list (RDS child processes, RDS processes, OS processes) to CloudWatch Logs.

Which RDS feature shows which SQL statements cause the most database load?

CloudWatch Database Insights (built on Performance Insights), which filters DB load by waits, SQL statements, hosts or users.

An Amazon RDS production database needs predictable disk I/O and consistently low latency. Which storage type fits?

Provisioned IOPS SSD storage. Choose it for demanding database I/O requirements.

Short Lambda invocations repeatedly open connections and exhaust an RDS database connection budget. What should the team use?

RDS Proxy. Point clients at the proxy so it can share and reuse backend database connections rather than opening one for each client request.

An application using RDS Proxy changes session state and database connections remain dedicated to individual clients. What explains the poor reuse?

Session pinning. The proxy reserves one backend connection until the client session ends so that session state remains consistent.

An RDS application repeats expensive read queries whose results can tolerate some staleness. Which complementary technique reduces database query work?

Cache reusable query results in ElastiCache. A cache hit avoids a repeated database query. Avoid this for queries requiring strong consistency.

Does adding RDS Proxy guarantee that every incoming connection is accepted during overload?

No. The proxy can queue or throttle demand, and it rejects connections if configured limits are exceeded.

A team is choosing RDS Proxy for an Amazon RDS for Oracle database. Is that engine supported?

No. RDS Proxy supports eligible RDS MariaDB, MySQL, PostgreSQL and SQL Server versions, plus Aurora MySQL and PostgreSQL.

An application needs database connection pooling but its team cannot operate or scale proxy servers. Which Amazon RDS feature fits?

RDS Proxy. AWS manages the proxy and scales its capacity automatically with demand.

An application connects to Amazon RDS through RDS Proxy and must encrypt the client-to-proxy connection. What should its connection settings require?

TLS/SSL to the RDS Proxy endpoint. Set the TLS requirement in the client connection configuration.

A production RDS for MySQL instance was created without encryption. Compliance now requires encryption at rest. What is the supported path?

Take a manual snapshot, copy it with encryption enabled (KMS key), restore a new instance from it, and switch over.

A blue/green deployment with an encrypted green environment also works.

An encrypted RDS snapshot must be shared with another AWS account, but sharing fails. The snapshot uses the default aws/rds key. What fixes it?

Copy the snapshot with a customer managed KMS key, share the copy, and grant the other account use of that key.

How does a Multi-AZ RDS deployment reduce downtime during operating system maintenance?

RDS patches the standby, fails over to it, then patches the old primary, which becomes the standby.

A team expects a database engine version upgrade on a Multi-AZ RDS instance to cause no downtime. Is that right?

No. Engine upgrades modify primary and standby together, so the database is down until the upgrade completes.

Can you switch an existing encrypted RDS instance to a different KMS key in place?

No. The key is fixed; copy a snapshot with the new key and restore, or use blue/green.

Which mechanism encrypts data in transit between an application and an Amazon RDS database?

SSL/TLS connections to the DB instance.

All connections to an RDS for SQL Server instance must use SSL. Which setting enforces it?

Set rds.force_ssl to 1 in its DB parameter group and reboot, because the parameter is static. (For RDS for MySQL the parameter is require_secure_transport.)

Can you create an encrypted read replica to get an encrypted copy of an unencrypted RDS instance?

No. A replica follows the source encryption state. Encrypt a snapshot copy and restore it, or use a blue/green deployment.

Auditors need RDS for MySQL audit logs searchable and retained for a year. What do you configure?

Publish the audit log to CloudWatch Logs and set the log group retention to a year.

A company runs RDS for SQL Server and its auditors require the database engine itself to encrypt data files. Which feature fits?

Transparent Data Encryption (TDE), available on RDS for Oracle and RDS for SQL Server.

It uses its own keys and can run alongside RDS encryption at rest.

Copying an encrypted RDS snapshot from us-east-1 to eu-west-1 fails when the team selects the source KMS key. What is required?

A KMS key in the destination Region (eu-west-1). KMS keys are Regional, so a cross-Region copy or encrypted read replica must use a key from the target Region.

An RDS DB instance is encrypted at rest with KMS. Which related data is also encrypted?

Its logs, automated backups, read replicas and snapshots, along with the instance storage.

Does an Amazon RDS Multi-AZ deployment guarantee no performance impact during automated backups?

No. Multi-AZ deployments can still experience elevated latency during automated backups. Account for backup activity when planning workload performance.

A Lambda function must connect to RDS for PostgreSQL without storing a database password. Which feature fits?

IAM database authentication: the function's role generates a 15-minute token used instead of a password.

An RDS DB instance was created with Public access set to Yes, but its DB subnet group contains private subnets. Can clients on the internet reach it?

No. Every subnet in the DB subnet group must be public for a publicly accessible DB instance, and the VPC needs DNS hostnames and DNS resolution turned on.

A legacy Oracle application needs OS-level customization of the database host and higher availability. Which managed option fits?

RDS Custom for Oracle with a Multi-AZ deployment. Regular RDS for Oracle gives no OS access, and EC2 leaves all failover work to the team. Note that AWS ends support for RDS Custom for Oracle on March 31, 2027.

A test database on RDS is used two days a week. Can the team simply keep it stopped between tests?

Only for up to 7 consecutive days; RDS then starts it automatically. For longer idle periods, take a snapshot and delete the instance, then restore when needed.

Can a client on the internet connect straight to an RDS Proxy endpoint?

No. RDS Proxy is never publicly accessible; clients reach it from inside the VPC or through connected networks.

An application connects to Aurora through RDS Proxy. During a writer failover, which client connections are affected?

Only connections in the middle of a transaction or SQL statement are canceled. Idle connections stay open and the proxy accepts new ones immediately, so the app must retry interrupted work.

How many same-Region read replicas can one RDS for MySQL source DB instance have?

Up to 15. Size each replica like the source, and scale replicas when you scale the source.

A team is choosing a data layout for a transactional database on Amazon RDS that frequently accesses complete records. Which layout fits?

A row-based layout. Transactional access to whole records suits rows; large analytical scans of selected fields suit a columnar layout.

Can an Amazon RDS DB instance be moved to a different VPC by changing its DB subnet group?

Yes, when eligible. Use a subnet group in the destination VPC; first resolve restrictions such as Multi-AZ deployment or read-replica relationships.

An application being evaluated for Amazon RDS organizes records with consistent attributes and relationships between tables. Which database model fits?

The relational model. Records are rows, attributes are columns, and tables can be related.

A team comparing Amazon RDS with a key-value database only needs to look up an object by its unique identifier. Which access model matches that requirement?

Key-value access. The unique key identifies the associated value to retrieve.

A team planning Amazon RDS capacity has several logical databases. Does every logical database require a separate DB instance?

No. A DB instance can contain multiple user-created databases, subject to its engine's capabilities.

A team estimates Amazon RDS cost for a database using Provisioned IOPS SSD storage. Which capacity charges should it include?

DB instance compute capacity, provisioned storage and provisioned IOPS. Size each for the workload requirements.

An application connects to Amazon RDS for MySQL with IAM database authentication. Does the IAM policy decide which tables it can read?

No. IAM decides who can connect as the database user; database privileges (GRANT, REVOKE) decide what that user can do.

You finished every topic of SAA-C03!

Your badge turned gold. Next step: book the exam on AWS. Once you pass, add yourself to Who passed.

Share

Share that you finished this certification

I finished every topic of AWS Certified Solutions Architect - Associate (SAA-C03) on Easy Review. Come study too!