Databases

Question 1

a _______ is an organized collection of various forms of data

Answer 1

database

Question 2

_______ are used by many applications, and are necessary to persist ____ through runs of an application.

Answer 2

databases, data

Question 3

you access the data stored in ______ a by _____ it

Answer 3

database, querying

Question 4

6 types of AWS databases services that support different use cases:

Answer 4

1. RDS (relational), 2 . Aurora (relational), 3. Dynamo DB (no SQL), 4. Document DB (document), 5. ElastiCache (in-memory datastore), 6. Neptune (graph)

Question 5

_____ DBs are good for data sets that have ________ between the _____ and you need to join multiple _____ to get the full picture

Answer 5

relational, relationships, tables, tables

Question 6

____ is a a service that makes it easy to launch and manage relational databases

Answer 6

RDS

Question 7

____ supports popular DB engines, and has high availability and ____ _____, using ___ ____deployment

Answer 7

RDS, fault tolerance, multi-AZ

Question 8

With ___, you are able to launch read _____ across regions in order to provide enhanced performance and durability.

Answer 8

RDS, replicas (read-only)

Question 9

_____ _____ is a read-only copy of your database for fast querying

Answer 9

Read replica

Question 10

______ only supports MySQL and PostgreSQL database engines

Answer 10

Aurora (relational)

Question 11

______ is __ __ faster than normal SQL and _ _ faster than normal PostgreSQL, and is managed by ___

Answer 11

Aurora, 5x faster, 3x, RDS

Question 12

_____ __ is a fully managed and serverless NoSQL key-value and document database

Answer 12

Dynamo DB (no SQL) - non relational

Question 13

No SQL = the database is ___ ____, and doesn’t enforce _______ between _____ like a ______ database

Answer 13

self-describing, relationships, tables, relational,

Question 14

_______ __ is a fully managed serverless ___- ____ , _____ database that supports _____ __

Answer 14

Document DB, non-relational, document, MongoDB

Question 15

_______ is a fully managed __-_____ _______ compatible with Redis or Memcached

Answer 15

ElastiCache, in-memory, datastore

Question 16

ElastiCache is good for regularly reading an _____ _____. Data can be ____, because it is stored in _____

Answer 16

intensive database, lost, memory

Question 17

_______ is a fully managed and serverless _____ _______ that supports ______ ______ datasets, like social media networks.

Answer 17

Neptune, graph database, highly connected

Question 18

Real world use cases for databases:
1. Migrate an on-premises Oracle database to the cloud?

Answer 18

RDS

Question 19

Real world use cases for databases:
2. Migrate an on-premises PostgreSQL to the cloud?

Answer 19

Aurora (or RDS)

Question 20

Real world use cases for databases:
3. Alleviate database load for data that is accessed often?

Answer 20

ElastiCache

Question 21

Real world use cases for databases:
4. Process large sets of user profiles and social interactions?

Answer 21

Neptune

Question 22

Real world use cases for databases:
5. NoSQL database fast enough to handle millions of requests per second?

Answer 22

Dynamo DB (no SQL)

Question 23

Real world use cases for databases:
6. Operate MongoDB workloads at scale?

Answer 23

Document DB