Technology Databases Flashcards

1
Q

Database

A
  • Allow us to collect, store, retrieve, sort, graph, and manipulate data
  • Is an organized collection of various forms of data
  • Used by many applications: web, mobile, services, and more
  • Necessary to persist data through runs of an application
  • You accesss the data stored in a database by querying it
  • Databases are typically controlled by a dtabase mgmt system
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Guess the service

A

Amazon Relational Database Service (RDS)

Easy to launch & manage relational databases

High availability and fault tolerance using multi AZ deployment

AWS manages the DB with automatic software patching, backups, op system maintenance and more.

Launch read replicas across regions in order to provide enhanced perf and durability

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

Guess the service

A

Amazon Aurora

5x faster than normal MySQL & 3x faster than PostgreSQL

Scales automatically while providing durability and high availability

Managed by RDS

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

Guess the service

A

Amazon Dynamo DB

Fully Managed NoSQL key value and document DB

Fully managed and serverless

Non relational

Scales automatically to massive workloads with fast perf

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

Guess the service

A

Amazon Document DB

Fully managed document DB that supports MongoDB

Fully managed and serverless

Non relational

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

Guess the service

A

Amazon ElastiCache

Fully managed in-memory datastore compatible with Redis & Memcached

Data can be lost

Offers high performance and low latency

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

Guess the service

A

Amazon Neptune

Fully managed graph DB that supports highly connected datasets

Graph DB service

Support highly connected datasets like social media networks

Fully managed serverless

Fast and reliable

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

Migrate an on premises Oracle database to the cloud

A

RDS

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

Migrate an on premises PostgreSQL database to the cloud

A

RDS

Aurora

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

Alleviate DB load for data that is accessed often

A

ElastiCache

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

Process large sets of user profiles and social interactions

A

Neptune

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

NoSQL database fast enough to handle millions of request per second

A

Dynamo DB

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

Operate MongoDB workload at scale

A

DocumentDB

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

RDS

A

Service that makes it easy to launch and manage relational databases

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

Aurora

A

Relational database compatible with MySQL and PostgreSQL that was created by AWS

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

DynamoDB

A

Fully managed NoSQL key-value and document database

17
Q

Neptune

A

Fully managed graph database that supports highly connected datasets

18
Q

DocumentDB

A

Fully managed document database that supports MongoDB

19
Q

Data Migration and Transfer

A

A lot of companies are migrating to the cloud, they need inexpensive, fast, and secure ways to move their on premises data to AWS

20
Q

Guess the service

A

Database Migration Service (DMS)

Helps you migrate databases to or within AWS

Continuous data replication

Supports homogeneous and heterogeneous migrations

Virtually no downtime

21
Q

DMS in the real world

Provide 3 use cases

A
  1. Oracle to Aurora MySQL. Migrate on prem Oracle DB to Aurora MySQL
  2. Oracle to Oracle.- Migrate on prem Oracle DB to Oracle on EC2
  3. RDS Oracle to Aurora MySQL.- Migrate an RDS Oracle DB to Aurora MySQL
22
Q

Guess the service

A

Server Migration Service (SMS)

Allows you to migrate on prem servers to AWS

Server saved as a new Amazon Machinge Image (AMI)

Use AMI to launch servers as EC2 instances

23
Q

AWS Snow Family

A

Snow Family allow you to transfer large amounts of on premises data to AWS using a physical device

24
Q

Guess the service

A

Snowcone

Smallest member of data transport services

8 Terabytes of usable storage

Offline shipping

Online with DataSync

25
Q

Guess the service

A

Snowball & Snowball Edge

Petabyte scale data transport solution

Transfer data in and out

Cheaper than internet transfer

Snowball Edge supports EC2 & Lambda

26
Q

Guess the service

A

Snowmobile

Multi petabte or exabyte scale

Data loaded to S3

Securely transported

27
Q

Guess the service

A

DataSync

Allow for online data transfer from on prem to AWS storage services like S3 or EFS

Copy data over Direct Connect or the internet

Copy data between AWS storage services

Replicate data cross-Region or cross-account

28
Q
A