Database Services Flashcards

Which AWS service is a fully managed Apache Cassandra-compatible database?

Answer: Amazon Keyspaces (for Apache Cassandra)

Amazon Keyspaces is a scalable, serverless, managed database service compatible with the Apache Cassandra query language (CQL).

A company's DynamoDB table experiences throttling during traffic spikes. Which feature should they enable to handle unpredictable workloads automatically?

Answer: DynamoDB On-Demand Mode

DynamoDB On-Demand Mode automatically scales read and write capacity to handle any traffic volume without capacity planning.

What does Amazon RDS handle automatically that would require manual effort on a self-managed database?

Answer: Patching the database software and taking backups

Amazon RDS automates routine tasks including hardware provisioning, database setup, patching, and backups.

Which DynamoDB feature allows you to capture a time-ordered sequence of item-level changes in a table?

Answer: DynamoDB Streams

DynamoDB Streams captures a time-ordered sequence of changes to items in a table, enabling event-driven architectures.

An e-commerce company needs its database to remain available across multiple AWS regions simultaneously for global users. Which service supports this?

Answer: Amazon DynamoDB Global Tables

DynamoDB Global Tables automatically replicate data across multiple AWS Regions, providing single-digit millisecond latency globally.

Which of the following database engines is NOT supported by Amazon RDS?

Answer: MongoDB

Amazon RDS supports MySQL, PostgreSQL, MariaDB, Oracle, SQL Server, and Aurora, but not MongoDB (which is supported via Amazon DocumentDB).

What is the benefit of using automated backups in Amazon RDS?

Answer: They allow point-in-time recovery within the backup retention period

RDS automated backups enable point-in-time recovery, allowing you to restore a database to any second within the retention window.