Database Services Flashcards

What type of database is Amazon DynamoDB?

Answer: NoSQL key-value and document database

DynamoDB is a fully managed NoSQL database service that supports both key-value and document data models.

Which Amazon RDS feature automatically creates a standby replica in a different Availability Zone to provide failover support?

Answer: Multi-AZ Deployment

RDS Multi-AZ Deployment maintains a synchronous standby replica in another AZ and automatically fails over if the primary instance fails.

A developer wants to offload database connection management to reduce overhead on an Amazon RDS instance. Which service helps?

Answer: Amazon RDS Proxy

Amazon RDS Proxy pools and manages database connections, reducing overhead and improving application scalability.

What is the primary use case for Amazon Redshift?

Answer: Performing large-scale data analytics and business intelligence

Amazon Redshift is a petabyte-scale data warehouse designed for OLAP queries and business intelligence workloads.

Which AWS service provides a fully managed ledger database with an immutable, cryptographically verifiable transaction log?

Answer: Amazon QLDB

Amazon QLDB (Quantum Ledger Database) maintains an immutable journal of all data changes, making it ideal for compliance-sensitive applications.

How does Amazon RDS Read Replicas differ from Multi-AZ Deployments?

Answer: Read Replicas improve read scalability; Multi-AZ provides high availability with automatic failover

Read Replicas scale read traffic asynchronously, while Multi-AZ maintains a synchronous standby for automatic failover.

Which AWS database service is MongoDB-compatible and fully managed?

Answer: Amazon DocumentDB

Amazon DocumentDB is a fully managed document database service that is compatible with MongoDB workloads and drivers.