Which managed database service is commonly used for scalable relational workloads in AWS?

Which managed database service is commonly used for scalable relational workloads in AWS?

• A. Amazon Aurora (MySQL/PostgreSQL compatible).
• B. Amazon RDS for Oracle.
• C. Amazon DynamoDB.
• D. Amazon Redshift.

Answer: (A)

Relational workloads that need scale and managed operations are best served by a purpose-built cloud relational database. Amazon Aurora fits this role because it’s a MySQL- and PostgreSQL-compatible engine designed for the cloud, with a storage layer that automatically scales from 10 GB up to 64 TB and replicates data across multiple Availability Zones for durability. It supports a large number of read replicas to handle high read traffic and provides fast failover to maintain availability. Aurora also offers serverless options for unpredictable workloads and handles automated backups, patching, and maintenance, reducing administrative overhead. This combination—cloud-optimized performance, automatic storage scaling, high availability, and serverless options—makes it the go-to choice for scalable relational workloads on AWS. DynamoDB is a NoSQL database, so it isn’t used for relational OLTP workloads. Redshift is a data warehouse designed for analytics rather than transactional processing. RDS for Oracle is a managed relational option, but Oracle licensing and cost considerations often make Aurora the more scalable and widely adopted pick for cloud-native relational workloads.

Relational workloads that need scale and managed operations are best served by a purpose-built cloud relational database. Amazon Aurora fits this role because it’s a MySQL- and PostgreSQL-compatible engine designed for the cloud, with a storage layer that automatically scales from 10 GB up to 64 TB and replicates data across multiple Availability Zones for durability. It supports a large number of read replicas to handle high read traffic and provides fast failover to maintain availability. Aurora also offers serverless options for unpredictable workloads and handles automated backups, patching, and maintenance, reducing administrative overhead. This combination—cloud-optimized performance, automatic storage scaling, high availability, and serverless options—makes it the go-to choice for scalable relational workloads on AWS.

DynamoDB is a NoSQL database, so it isn’t used for relational OLTP workloads. Redshift is a data warehouse designed for analytics rather than transactional processing. RDS for Oracle is a managed relational option, but Oracle licensing and cost considerations often make Aurora the more scalable and widely adopted pick for cloud-native relational workloads.