AWS Certified Solutions Architect – Associate (SAA-C02) — Question 467

A company is investigating potential solutions that would collect, process, and store users' service usage data. The business objective is to create an analytics capability that will enable the company to gather operational insights quickly using standard SQL queries. The solution should be highly available and ensure
Atomicity, Consistency, Isolation, and Durability (ACID) compliance in the data tier.
Which solution should a solutions architect recommend?

Answer options

• A. Use an Amazon Timestream database.
• B. Use an Amazon Neptune database in a Multi-AZ design.
• C. Use a fully managed Amazon RDS for MySQL database in a Multi-AZ design.
• D. Deploy PostgreSQL on an Amazon EC2 instance that uses Amazon Elastic Block Store (Amazon EBS) Throughput Optimized HDD (st1) storage.

Correct answer: C

Explanation

Amazon RDS for MySQL in a Multi-AZ deployment offers a fully managed, highly available relational database that natively supports standard SQL queries and guarantees ACID compliance. Amazon Timestream is a time-series database and Amazon Neptune is a graph database, neither of which are standard relational databases suited for general SQL queries. Deploying PostgreSQL on an Amazon EC2 instance with EBS st1 storage requires significant administrative overhead to manage high availability and uses storage that is not optimized for transactional database workloads.