Database Services Flashcards

Which AWS database service is best suited for storing and querying highly connected data, such as social network relationships?

Answer: Amazon Neptune

Amazon Neptune is a fully managed graph database service designed for highly connected datasets like social networks.

A company needs a fully managed in-memory caching service to reduce database load. Which AWS service should they use?

Answer: Amazon ElastiCache

Amazon ElastiCache is a fully managed in-memory caching service supporting Redis and Memcached to improve application performance.

Which feature of Amazon Aurora makes it different from standard MySQL or PostgreSQL?

Answer: It automatically replicates data across 3 Availability Zones with 6 copies

Aurora automatically replicates data six times across three Availability Zones, providing high availability and durability.

What is Amazon DynamoDB Accelerator (DAX) primarily used for?

Answer: Providing microsecond read latency for DynamoDB tables

DAX is an in-memory cache for DynamoDB that delivers microsecond response times for read-heavy workloads.

Which AWS service would you use to migrate an on-premises Oracle database to Amazon Aurora with minimal downtime?

Answer: AWS Database Migration Service (DMS)

AWS DMS enables continuous data replication from source to target databases, minimizing downtime during migration.

A startup needs a serverless database that scales automatically and charges only for actual usage. Which service fits best?

Answer: Amazon Aurora Serverless

Amazon Aurora Serverless automatically starts, scales, and shuts down based on application demand, charging only for consumed capacity.

Which AWS database service is designed specifically for time-series data such as IoT sensor readings?

Answer: Amazon Timestream

Amazon Timestream is a purpose-built time-series database for collecting and analyzing data that changes over time, like IoT metrics.