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 are ACID transactions in databases?
Open an interactive chat with Bash
What is Multi-AZ high availability in Amazon RDS?
Open an interactive chat with Bash
How does point-in-time recovery work in Amazon RDS?