Databases and Analytics

Question 1

Relational Database

Answer 1

Relations between tables in a database

Question 2

Language for relational databases

Answer 2

SQL

Question 3

NoSQL DB Benefits

Answer 3

Flexible
Scalable
High-performance
Highly functional

Question 4

RDS acronym

Answer 4

Relational Database Service

Question 4

What are key-value, Document, graph, in-memory, and search databases examples of?

Answer 4

NoSQL Databases

Question 4

NoSQL DB’s purpose built for…

Answer 4

Specific data models with flexible schemas for modern apps

Question 4

NoSQL data type

Answer 4

JSON

Question 4

What database type can be nested?

Answer 4

NoSQL (JSON)

Question 4

AWS managed DB benefits

Answer 4

Provisioning, HA, Scaling, Backup, restore, OS patching, monitoring, alerting

Question 4

AWS service for Oracle

Answer 4

RDS

Question 5

RDS

Answer 5

Managed DB service using SQL

Question 5

AWS service for Postgres

Answer 5

RDS

Question 5

AWS service for MariaDB

Answer 5

RDS

Question 6

AWS service for Aurora

Answer 6

RDS

Question 7

Can you SSH into RDS instances

Answer 7

no

Question 8

DB types supported by Aurora (2)

Answer 8

PostgreSQL
MySQL

Question 9

Aurora DB max size

Answer 9

128TB

Question 10

How much more does Aurora cost over RDS (percent)

Answer 10

20%

Question 11

Which DB type is more cloud native (RDS or Aurora)?

Answer 11

Aurora

Question 12

RDS Read Replica

Answer 12

Scale read workload

Question 13

Max RDS read replicas

Answer 13

15

Question 14

RDS Multi-AZ

Answer 14

Failover in case of AZ outage

Question 15

How many failover AZ’s in RDS multi-AZ?

Answer 15

1

Question 16

RDS Multi-Region

Answer 16

Read replicas in different regions

Question 17

In-Memory Database service

Answer 17

ElastiCache

Question 18

AWS service for Redis

Answer 18

ElastiCache

Question 19

AWS service for Memcached

Answer 19

Elasticache

Question 20

Benefit of ElastiCache

Answer 20

Relieve load from RDS

Question 21

DynamoDB benefits

Answer 21

Fully managed HA with replication in 3 AZ

Question 22

Which DB type is "serverless?"

Answer 22

DynamoDB

Question 23

Low latency DB type

Answer 23

Dynamo DB

Question 24

Dynamo DB Relational or NoSQL?

Answer 24

NoSQL

Question 25

DynamoDB Accelorator (DAX)

Answer 25

In-memory cache for DynamoDB

Question 26

DynamoDB Global Tables

Answer 26

Make DynamoDB accessible with low latency in multiple regions

Question 27

Which DB type has Active-Active Replication

Answer 27

DynamoDB

Question 28

Which table allows writing in Dynamo DB?

Answer 28

All of them

Question 29

Redshift OLTP or OLAP

Answer 29

OLAP

Question 30

DB with hourly load interval

Answer 30

Redshift

Question 31

Database with columnar storage

Answer 31

Redshift

Question 32

Database that has a data warehouse to do computation/analytics/visualization on datasets?

Answer 32

Redshift

Question 33

BI Tools for Redshift (2)

Answer 33

Quicksight Tableau

Question 34

Amazon EMR acronym

Answer 34

Elastic MapReduce

Question 35

EMU helps provision...

Answer 35

Hadoop clusters

Question 36

DB for machine learning, web indexing, big data

Answer 36

EMR

Question 37

Serverless query service for S3 analytics

Answer 37

Amazon Athena

Question 38

Amazon Athena (SQL or NoSQL)

Answer 38

SQL

Question 39

Database for BI for VPN flow logs, ELB logs, Cloudtrail Trails, etc...

Answer 39

Amazon Athena

Question 40

Amazon Quicksight purpose

Answer 40

BI Dashboards Visualizations

Question 41

DocumentDB (SQL or NoSQL)

Answer 41

NoSQL

Question 42

DocumentDB is AWS version of...

Answer 42

MongoDB

Question 43

DocumentDB max size

Answer 43

64TB

Question 44

DocumentDB is similar to what other Amazon service?

Answer 44

Aurora

Question 45

DocumentDB number of AZ's

Answer 45

3

Question 46

Neptune is

Answer 46

Graph DB

Question 47

Neptune Graph DB use cases...

Answer 47

Social networking Fraud detection Recommendation engines

Question 48

Amazon QLDB purpose

Answer 48

Review history of all changes to app data

Question 49

Which DB type is similar to blockchain

Answer 49

QLDB

Question 50

Immutable DB service

Answer 50

QLDB

Question 51

QLDB central or decentralized

Answer 51

Central DB

Question 52

Managed Blockchain central or decentralized

Answer 52

Decentralized

Question 53

DB product for financial transactions

Answer 53

QLDB

Question 54

Hyperledger Fabric or Ethereum Product...

Answer 54

Amazon Managed Blockchain

Question 55

AWS Glue

Answer 55

Managed ETL service

Question 56

ETL used for...

Answer 56

Prepare and transform data for analytics

Question 57

DMS Acronym

Answer 57

Database Migration Service

Question 58

Can DMS support migrating from one database type to another?

Answer 58

Yes (ex. Microsoft SQL to Oracle)

Question 59

Key/Value Database product...

Answer 59

DynamoDB & DAX