Which AWS service is a relational database compatible with MySQL and PostgreSQL?

Question

Options

• AAmazon Redshift
• BAmazon DynamoDB
• CAmazon Aurora
• DAmazon Neptune

• A
  7% (3)
• B
  2% (1)
• C
  88% (36)
• D
  2% (1)

Explanation

Amazon Aurora is AWS's fully managed relational database service that is specifically designed to be compatible with both MySQL and PostgreSQL, offering up to 5x the performance of standard MySQL and 3x that of PostgreSQL while maintaining full compatibility with those engines.

Why the distractors are wrong:

• Amazon Redshift (A) is a data warehousing service optimized for analytical queries (OLAP), not a traditional relational database for transactional workloads.
• Amazon DynamoDB (B) is a fully managed NoSQL key-value and document database - it is not relational and has no MySQL/PostgreSQL compatibility.
• Amazon Neptune (D) is a managed graph database service designed for highly connected datasets, not a relational database.

Memory Tip: Think of Aurora as the upgraded, cloud-native twin of MySQL and PostgreSQL - the name "Aurora" suggests something superior and shining, which reflects its positioning as a high-performance, drop-in replacement for those two popular open-source relational databases. If the question mentions "MySQL/PostgreSQL compatible relational database," Aurora is always the answer.

No community discussion yet for this question.