Databases

Question 1

What are the types of DBs?

Answer 1

RDBMS - RDS Aurora - Great for joins
NoSQL - DynamoDB (Json), ElastiCache (key/value pairs), Neptune (graphs) - no joins, no SQL
Object Store - S3
Data Warehouse - Redshift, Athena
Search - Elastic Search (Free text, unstructured searches)
Graphs: Neptune. Displays relationships between data

Question 2

What kind of DB is Neptune?

Answer 2

Graph

Question 3

What is RedShift?

What is redshift enhanced VPC Routing?

Since redshit has not multi-az mode how can you configure Redshit for Disaster Recovery?

What is redshift spectrum?

Answer 3

It’s a BI tool that allows you to quickly perfrom analysis on huge datasets (PB in size).

It allows you to copy and unload data from your datasource without going through the public internet.

You can enable snapshots, then configure it to automatically copy snapshots of a cluster to another AWS region.

If you already have a RedShift cluster set up, you can utilize RedShit spectrum to query directly to S3 without copying the data into your cluster. This will submit the query to thousands of RedShift spectrum nodes which will query S3 and return the result back to your cluster.

Question 4

What is AWS Glue?

Answer 4

It’s an ETL tool