Databases

Question 1

read replica

Answer 1

a read-only copy of your database for fast querying

Question 2

database

Answer 2

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

Question 3

what are graph databases good for?

Answer 3

highly-connected data sets like social media networks

Question 4

which amazon services does Snowball Edge natively support?

Answer 4

EC2 and Lambda

Question 5

why are databases necessary?

Answer 5

to persist data thru runs of an application

Question 6

which database is in memory?

Answer 6

ElastiCache

Question 7

which database is for Mongo Documents

Answer 7

DocumentDB

Question 8

which database is good for social networking?

Answer 8

Neptune

Question 9

which databases are relational?

Answer 9

RDS and Aurora

Question 10

which database option uses NoSQL

Answer 10

DynamoDB

Question 11

Amazon RDS

Answer 11

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

Question 12

Amazon Aurora

Answer 12

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

Question 13

Dynamo DB

Answer 13

fully managed noSQL key/value and document DB

• serverless
• non-relational
• scales automatically to massive workloads with fast performance

Question 14

Document DB

Answer 14

fully managed document database that supports Mongo DB

- non-relational

Question 15

ElastiCache

Answer 15

• 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

Question 16

Redis

Answer 16

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.

Question 17

Amazon Neptune

Answer 17

fully managed graph database

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

Question 18

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

Answer 18

RDS

Question 19

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

Answer 19

RDS with Aurora

Question 20

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

Answer 20

ElastiCache

Question 21

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

Answer 21

Neptune

Question 22

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

Answer 22

DynamoDB

Question 23

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

Answer 23

Document DbB

Question 24

DMS

Answer 24

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

Question 25

What are some examples of DMS migrations?

Answer 25

- Oracle to Aurora MySQL - Oracle to Oracle on EC2 - RDS Oracle to Aurora MySQL

Question 26

SMS

Answer 26

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

Question 27

What is the Snow Family used for?

Answer 27

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

Question 28

Snowcone

Answer 28

- 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

Question 29

Snowball

Answer 29

petabyte-scale data transport solution - can transfer data in and out - cheaper than internet transfer

Question 30

example use cases for Snowball

Answer 30

- migrating HIPAA data offline | - movie teams upload and encode movie footage from multiple cameras and migrate to S3

Question 31

Snowball Edge

Answer 31

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

Question 32

Snowmobile

Answer 32

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

Question 33

Data Sync

Answer 33

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