AWS Databases

Question 1

List 6 different types of databases supported by the AWS ecosystem?

Answer 1

• RDS
• Aurora
• DynamoDB
• DocumentDB
• ElastiCache
• Neptune

Question 2

What is Amazon Relational Database Service (RDS)?

Answer 2

RDS is a service that makes it easy to launch and manage relational databases.

• Supports popular database engines
• Offers high availability and fault tolerance using Multi-AZ deployment option
• AWS manages the database with automatic software patching, automated backups, operating system maintenance, and more.
• Amazon RDS Read Replicas provide enhanced performance and durability for RDS database (DB) instances. They make it easy to elastically scale out beyond the capacity constraints of a single DB instance for read-heavy database workloads.

Question 3

What is Amazon Aurora?

Answer 3

Aurora is a relational database compatible with MySQL and PostgreSQL that was created by AWS.

• Supports MySQL and PostgreSQL database engines
• 5x faster than normal MySQL and 3x faster than normal PostgreSQL
• Scales automatically while providing durability and high availability
• Managed by RDS

Question 4

What is Amazon DynamoDB?

Answer 4

DynamoDB is a fully managed NoSQL key-value and document database.

• NoSQL key-value database
• Fully managed and serverless
• Non-relational
• Scales automatically to massive workloads with fast performance

Question 5

What is Amazon DocumentDB?

Answer 5

DocumentDB is a fully managed document database that supports MongoDB.

• Document database
• MongoDB compatible
• Fully managed and serverless
• Non-relational

Question 6

What is Amazon ElastiCache?

Answer 6

ElastiCache is a fully managed in-memory datastore compatible with Redis or Memcached.

• In-memory datastore
• Compatible with Redis or Memcached engines
• Data can be lost
• Offers high performance and low latency

Question 7

What is Amazon Neptune?

Answer 7

Neptune is a fully managed graph database that supports highly connected datasets.

• Graph database service
• Supports highly connected datasets like social media networks
• Fully managed and serverless
• Fast and reliable

Question 8

Scenario: How would you migrate on-premises oracle database to the cloud?

Answer 8

RDS

Question 9

Scenario: How would you migrate an on-premises PostgreSQL database to the cloud?

Answer 9

• RDS
• Aurora

Question 10

Scenario: How would you alleviate database load for data that is accessed often?

Answer 10

• ElastiCache

Question 11

Scenario: How would you process large sets of user profiles and social interactions?

Answer 11

• Amazon Neptune

Question 12

Scenario: How to operate MongoDB workloads at scale?

Answer 12

• DocumentDB

Question 13

Scenario: How use NoSQL database fast enough to handle millions of requests per second?

Answer 13

• DynamoDB