CLF-C02 Practice Question 76: MySQL Compatible Database
AWS Certified Cloud Practitioner (CLF-C02) · Test 8 · question 6 of 10
A company runs a busy MySQL database on premises. It wants a fully managed relational database on AWS that is compatible with MySQL, so its existing code and tools keep working. Storage should grow automatically as data grows, and the company wants higher throughput than standard MySQL on similar hardware. Which service meets these requirements?
Show answer and explanation
Answer:
Amazon Aurora is a fully managed relational database engine compatible with MySQL and PostgreSQL, so the code, tools and applications used with those databases work with Aurora. It uses a high-performance distributed storage subsystem that grows automatically as needed, and AWS states it delivers several times the throughput of the standard engines on similar hardware. Aurora is part of Amazon RDS, which handles provisioning, patching, backup and recovery.
Option B, Amazon DynamoDB, is a NoSQL key-value database. The application would need a new data model and new code, not its existing MySQL tools. Option C, Amazon Redshift, is a data warehouse for analytical queries over large data sets, not the transactional database behind a running application. Option D, Amazon DocumentDB, is a managed document database compatible with MongoDB, not MySQL.
Reference: What is Amazon Aurora?