Databases Flashcards

1
Q

What are Relational Databases?

A

RDS is only for relational databases.

Don’t forget the supported database engines:

Amazon Aurora

PostgreSQL

My SQL

MariaDB

Oracle Database

SQL Server.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What is an Aurora database?

A

Only supports PostgreSQL and My SQL (faster and cheaper).

Managed by RDS. *created by AWS

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is DynamoDB?

A

A No SQL database

Fully managed and serverless (meaning the patching and upgrading is done by AWS)

Fast enough to handle millions of request per second

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What is ElastiCache?

A

An in-memory datastore

Fully managed in-memory datastore

Compatible with Redis and Memcached

Data can be lost

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What is Neptune?

A

A graph database

Helps you create social media graphs

Good for highly connected dataset like social media networks

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What is DocumentDB?

A

A graph database.

Supports MongoDB

Fully managed and serverless

Non-relational

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What is some real world use cases of Aurora database?

A

RDS- migrate a on-prem Oracle database to the cloud

RDS & Aurora – migrate an on-prem PostgreSQL database to the cloud

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What are some real world use cases of ElastiCache?

A

ElastiCache - Alleviate database load for data that is accessed often

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What are some real world use cases of Neptune?

A

Neptune - Process large sets of user profiles and social interactions

Document Databases

How well did you know this?
1
Not at all
2
3
4
5
Perfectly