Exam AWS Certified Solutions Architect - Associate SAA-C02 topic 1 question 111 discussion

Option C is right. AWS RDS always confirms to the ACID system: Atomicity, Consistency, Isolation, and Durability

Option C for the following reasons: 1. Standard SQL queries requirement in the question eliminates choices A & B. 2. Highly available requirement in the question makes it C (Multi AZ design)

C is correct - ACID

Atomicity, Consistency, Isolation, and Durability: multi az rds

Answer is C. SQL queries for highly connected data are complex and hard to tune for performance. Instead, Amazon Neptune allows you to use the popular graph query languages Apache TinkerPop Gremlin and W3C’s SPARQL to execute powerful queries that are easy to write and perform well on connected data.Neptune doesnt support simple SQL.

Answer is C Relational databases store data with predefined schemas and relationships between them. These databases are designed to support ACID (atomicity, consistency, isolation, durability) transactions, and maintain referential integrity and strong data consistency. Many traditional applications, enterprise resource planning (ERP), customer relationship management (CRM), and e-commerce use relational databases to store their data.

RDS for MySQL is ACID compliant + Multi AZ for HA

https://aws.amazon.com/neptune/faqs/ neptune is ACID compliant, but it doesn't use SQL to query

Because of ACID

RDS, with SQL Nepute is also ACID complaint but its not SQL. hence answer is C RDS

I'll go for C

Relational databases have the ACID property https://docs.aws.amazon.com/wellarchitected/latest/performance-efficiency-pillar/database-architecture-selection.html

ACID is a property of Relational Database and not of either Graph or Timeseried DB.

i think it's A . . https://aws.amazon.com/timestream/?whats-new-cards.sort-by=item.additionalFields.postDateTime&whats-new-cards.sort-order=desc&amazon-timestream-blogs.sort-by=item.additionalFields.createdDate&amazon-timestream-blogs.sort-order=desc

I'll go with B Read its features carefully. This is the real one ACID compliant. https://aws.amazon.com/neptune/features/ https://aws.plainenglish.io/specialty-databases-in-aws-qldb-timestream-neptune-and-keyspaces-757ef79e0966

I think A could be right See https://aws.amazon.com/timestream/?whats-new-cards.sort-by=item.additionalFields.postDateTime&whats-new-cards.sort-order=desc&amazon-timestream-blogs.sort-by=item.additionalFields.createdDate&amazon-timestream-blogs.sort-order=desc Amazon Timestream enables you to easily store and analyze data at scale. For example, with clickstream data, you can use Amazon Timestream to store and process the incoming and outgoing web traffic for your applications. Amazon Timestream also provides aggregate functions to analyze this data and get insights such as path-to-purchase and shopping cart abandonment rate.

C is better than D(managing own database, further io1/2 recommended for EC2 EBS volumes when doing databases) Additional Note-RDS/Aurora are NOT serverless(EC2 deployed at time of creation by us) Neptune is a managed(not serverless) database for 'GRAPHS'. It is suited for highly relational data. Amazon Timestream is a fast, scalable, and serverless time series database service for IoT and operational applications that makes it easy to store and analyze trillions of events per day.