Databases Flashcards

1
Q

read replica

A

a read-only copy of your database for fast querying

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

database

A

organized collection of various forms of data, necessary to persist data thru runs of an application

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

what are graph databases good for?

A

highly-connected data sets like social media networks

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

which amazon services does Snowball Edge natively support?

A

EC2 and Lambda

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

why are databases necessary?

A

to persist data thru runs of an application

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

which database is in memory?

A

ElastiCache

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

which database is for Mongo Documents

A

DocumentDB

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

which database is good for social networking?

A

Neptune

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

which databases are relational?

A

RDS and Aurora

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

which database option uses NoSQL

A

DynamoDB

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

Amazon RDS

A

Relational Database Service

  • supports popular SQL databases: SQLServer, PostGres, MySQL, Oracle, Aurora, MariaDB
  • multi-AZ deployment (high availability & fault tolerance)
  • AWS manages the database updates and maintenance
  • can launch read-replicas across regions
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Amazon Aurora

A

relational database compatible with MySQL and PostGres that was created by AWS

  • 5x faster than MySQL; 3x faster than PostGres
  • scales automatically while providing high durability and availability
  • managed by RDS
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Dynamo DB

A

fully managed noSQL key/value and document DB

  • serverless
  • non-relational
  • scales automatically to massive workloads with fast performance
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Document DB

A

fully managed document database that supports Mongo DB

- non-relational

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

ElastiCache

A
  • fully-managed in-memory data store
  • compatible with Redis or MemCached engines
  • data can be lost since it’s stored in memory
  • high performance and low latency
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Redis

A

Redis, which stands for Remote Dictionary Server, is a fast, open-source, in-memory key-value data store for use as a database, cache, message broker, and queue. Redis now delivers sub-millisecond response times enabling millions of requests per second for real-time applications in Gaming, Ad-Tech, Financial Services, Healthcare, and IoT. Redis is a popular choice for caching, session management, gaming, leaderboards, real-time analytics, geospatial, ride-hailing, chat/messaging, media streaming, and pub/sub apps.

17
Q

Amazon Neptune

A

fully managed graph database

  • supports highly-connected data sets
  • serverless
  • fast and reliable
18
Q

which database service would you use to migrate an on-premises database to the cloud?

A

RDS

19
Q

which database service would you use to migrate an on-premises PostGres SQL database to the cloud?

A

RDS with Aurora

20
Q

Which database service would alleviate load for data that is accessed often?

A

ElastiCache

21
Q

which database service can process large sets of user profiles and social interactions?

A

Neptune

22
Q

which database service is a NoSQL database large enough to handle millions of requests per second

A

DynamoDB

23
Q

which database service allows you to operate MongoDB workloads at scale?

A

Document DbB

24
Q

DMS

A

Database Migration Service

  • helps migrate databases to or within AWS
  • migrate on-prem data to AWS
  • continuous data replication
  • supports homogenous and heterogeneous migrations
  • virtually no downtime
25
Q

What are some examples of DMS migrations?

A
  • Oracle to Aurora MySQL
  • Oracle to Oracle on EC2
  • RDS Oracle to Aurora MySQL
26
Q

SMS

A

Server Migration Service

  • allows you to migrate on-prem servers to AWS
  • server is saved as a new AMI
  • can use the AMI to launch servers as EC2 instances
27
Q

What is the Snow Family used for?

A

when you have large amounts of data that need to be moved/migrated
- edge computing, edge storage, and data transfer devices

28
Q

Snowcone

A
  • 4.5 lbs with 8 TB of usable storage
  • smallest member of the snow family
  • transfer data with offline shipping or online w/ AWS Data Sync
  • rugged, durable, self-contained
  • edge computing
29
Q

Snowball

A

petabyte-scale data transport solution

  • can transfer data in and out
  • cheaper than internet transfer
30
Q

example use cases for Snowball

A
  • migrating HIPAA data offline

- movie teams upload and encode movie footage from multiple cameras and migrate to S3

31
Q

Snowball Edge

A

edge computing, storage and transfer device that supports EC2 and Lambda
- allows you to run apps in a disconnected environment

32
Q

Snowmobile

A

multi-petabyte or exabyte scale

  • data is driven and securely transported via truck with escort car
  • use when moving your entire data center to AWS
33
Q

Data Sync

A

allows for online data transfer from on-premises to AWS services like S3 or EFS

  • copy data via Direct Connect or over the internet
  • can be used to replicate data cross-region or cross-account