AWS Certified Solutions Architect Associate SAA-C03 Practice Question
A solutions architect must select an AWS managed database service to store highly relational data that requires ACID transactions, SQL joins, and point-in-time recovery. Engineers will access the data with standard SQL queries and need automatic multi-AZ high availability without managing the underlying infrastructure. Which AWS database service best meets these requirements?
Amazon RDS (for example, Amazon RDS for PostgreSQL or MySQL) is a fully managed relational database service that supports SQL joins, ACID transactions, and automated backups while providing Multi-AZ deployments for high availability. Amazon Neptune is optimized for graph use cases, Amazon DynamoDB is a NoSQL key-value and document store, and Amazon ElastiCache for Redis is an in-memory cache-not a relational database.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What types of data structures are best suited for Amazon Neptune?
Open an interactive chat with Bash
What are the key features of Amazon RDS and Amazon Aurora that make them suitable for relational data?
Open an interactive chat with Bash
How does Amazon Neptune handle queries differently from relational database services?