Databases Flashcards

1
Q

Relational Databases

A
  • Amazon Aurora
  • Amazon RDS
  • Amazon Redshift
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Use case for relational databases

A
  • Traditional applications
  • CRM
  • Enterprise Resource Planning
  • E-Commerce
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

A mySQL and PostgresSQL compatible database built for the cloud

A

Amazon Aurora

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

Easily set up, use, and scale multiple database engines

A

Amazon RDS

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

A cloud data warehouse

A

Amazon Redshift

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

Use case for Key-Value Databases

A
  • High traffic web applications, E-Commerce, and gaming
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Key-Value Databases

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

Fast and flexible NoSQL database for any scale

A

Amazon DynamoDB

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

Use case for In-Memory Databases

A
  • Caching
  • Session management
  • Gaming leaderboards
  • Geospatial applications
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

In-Memory Databases

A
  • Amazon ElastiCache
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Managed, in-memory data store service for Redis, and Memcached

A

Amazon ElastiCache

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

Use case for Document Database

A
  • Content management
  • Catalogues
  • User profiles
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Document Database

A
  • Amazon DocumentDB
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

MongoDB compatible fast, scalable, highly available document database

A

Amazon DocumentDB

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

Amazon RDS

A
  • Easy to set up
  • Fully managed
  • Scalable
  • Automated backups
  • Automatic host replacement
  • Cost effective
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

DynamoDB

A
  • NoSQL (not typically SQL, potentially “sql-like”)
  • Key-value document database
  • Single-digit millisecond performance
  • Fully managed
  • multiple regions
  • Built in security, backup, and restore
  • Can handle > 20 million requests per second
  • works with serverless
  • works great for mobile app data
17
Q

Amazon Relational Database Services (RDS)

A

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
- AWS managed DB
- Read replicas across regions for performance and durability

18
Q

Amazon Aurora

A

Relational database compatible with MySQL and PostgreSQL

19
Q

Amazon DynamoDB

A

is a fully managed NoSQL key-value and document database.
- fully managed and serverless
- non-relational
- scales automatically to workload

20
Q

Amazon DocumentDB

A

is a fully managed document database that supports MongoDB.
- non-relational
-

21
Q

Amazon Elasticache

A

is a fully managed in-memory datastore compatible with Redis or Memcached
- data can be lost
- high performance and low latency

22
Q

Amazon Neptune

A

is a fully managed graph database that supports highly connected datasets.
- supports highly connected datasets like social media networks

23
Q

Best database to migrate an on-premises oracle database to the cloud

A

Amazon RDS

24
Q

Best database to migrate an on-premises postgreSQL database to the cloud

A

Amazon RDS, Amazon Aurora

25
Q

Best database to alleviate database load for data that is accessed often

A

Elasticache

26
Q

Best database to process large sets of user profiles and social interactions

A

Amazon Neptune

27
Q

Best database for NoSQL fast enough to handle millions of requests per second

A

Amazon DynamoDB