A Company Is Investigating Potential Solutions That Would Collect, Process

question 69

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 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.