Which AWS-native relational database is compatible with MySQL and PostgreSQL and provides commercial-grade performance and availability through a cloud-native design?

1 / 1
Select an answer
CorrectB

Explanation

Question Overview

Selecting a high-performance, AWS-native RDB compatible with MySQL/PostgreSQL.

Requirements to satisfy
  • 1「compatible with MySQL and PostgreSQL」Compatible with existing MySQL/PostgreSQL applications = Aurora
  • 2「performance and availability」High performance and availability from a cloud-native design
  • 3「AWS-native relational database」The positioning of Aurora
Per-option explanation
AIncorrect

Amazon DynamoDB

DynamoDB is AWS's fully managed NoSQL (key-value) database.

It is not a MySQL/PostgreSQL-compatible relational database, so it is incorrect.

BCorrect

Amazon Aurora

Correct. Amazon Aurora is an AWS-native relational database compatible with MySQL and PostgreSQL. It delivers higher performance and throughput than standard MySQL/PostgreSQL and provides high availability and durability with storage that spans multiple Availability Zones.

CIncorrect

Amazon RDS for MySQL

Amazon RDS for MySQL is a service that runs the community edition of MySQL as-is in a managed manner.

MySQL compatibility and being managed are shared, but the description of an AWS-native, cloud-native, high-performance RDB redesigned from the storage layer matches Aurora, so this is incorrect.

DIncorrect

Amazon Redshift

Amazon Redshift is a data warehouse specialized in aggregating and analyzing large volumes of data.

Being SQL-based is shared, but it is not a MySQL/PostgreSQL-compatible transactional RDB, so this description matches Aurora and this is incorrect.

Key Takeaway

'MySQL/PostgreSQL compatible' and 'high-performance AWS-native RDB' point to Amazon Aurora. The difference from standard RDS for MySQL (the community edition as-is) is whether it is an AWS-native, cloud-native design. NoSQL is DynamoDB, and analytics is Redshift.

Related Links