Which service is a fully managed relational database engine compatible with MySQL and PostgreSQL?

• A. Amazon RDS
• B. Amazon DynamoDB
• C. Amazon Aurora
• D. Amazon DocumentDB (with MongoDB compatibility)

Answer: (C)

The key idea is recognizing an AWS database engine that is designed to be compatible with both MySQL and PostgreSQL and is fully managed by AWS. Amazon Aurora fits this exactly. It’s a relational database engine offered as part of the RDS family, built to be compatible with MySQL and PostgreSQL at the application level, so you can use the same drivers, tools, and SQL you already rely on while gaining AWS-managed benefits. Aurora handles provisioning, patching, backups, automated failover across availability zones, and storage scaling, delivering high availability and performance improvements over standard open‑source engines.

DynamoDB isn’t a relational database; it’s a NoSQL key‑value store. DocumentDB is MongoDB‑compatible but not relational. While RDS is the managed service that can run MySQL or PostgreSQL, the engine designed to be compatible with both is Aurora, which is why it’s the best match for the requirement.