A Company Is Investigating Potential Solutions That Would Collect, Process

Multiple Choice

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?

A) Use Amazon DynamoDB transactions.
B) Create 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 EBS Throughput Optimized HDD (st1) storage.