Which solution should a solutions architect recommend?

By:
In: SAA-C02
Tagged:
With: 1 Comment
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 ensureAtomicity, Consistency, Isolation, and Durability (ACID) compliance in the data tier.

Which solution should a solutions architect recommend?

Use an Amazon Timestream database.

Use an Amazon Neptune database in a Multi-AZ design.

Use a fully managed Amazon RDS for MySQL database in a Multi-AZ design.

Deploy PostgreSQL on an Amazon EC2 instance that uses Amazon Elastic Block Store (Amazon EBS) Throughput Optimized HDD (st1) storage.

Explanations:

Amazon Timestream is designed for time-series data and does not fully support ACID transactions required for operational analytics with standard SQL queries.

Amazon Neptune is a graph database and while it can provide high availability in a Multi-AZ design, it does not support standard SQL queries and may not ensure full ACID compliance as expected for general analytics use cases.

Amazon RDS for MySQL is a fully managed relational database that provides ACID compliance, supports standard SQL queries, and can be deployed in a Multi-AZ configuration for high availability. This makes it suitable for the company’s analytics needs.

Deploying PostgreSQL on an EC2 instance lacks the management and high availability features provided by Amazon RDS, and it also requires additional operational overhead, making it less ideal for a solution aimed at quickly gathering operational insights.

2025-10-13

1 Comment

  1. Benjamin
    Author

    I arrange that the answer is:
    Use a fully managed Amazon RDS for MySQL database in a Multi-AZ design.

Leave a Reply to Benjamin Cancel reply

Your email address will not be published. Required fields are marked *

15 − 4 =