Databases Flashcards
What is an RDBMS (Aurora/Postgres) good for?
SQL, joins, OLTP etc
What is OLTP?
Online Transaction Processing
What is a NoSQL DB (Dynamo/Elasticache) good for?
key/value pairs, no joins, no SQL
What is object store (S3) good for?
Big objects and data backups
What is a data warehouse (RedShift/Athena) good for?
SQL analytics, business insights
What 2 RDBMS is the Aurora API compatible with?
- Postgres
- MySQL
Where is the Aurora data stored?
It is stored in 6 replicas across 3 availability zones
Why would Aurora be Global?
It can be Global for disaster recovery or latency purposes
How big can the Aurora Auto Scaling storage be?
Between 10GB and 128GB
What is Aurora serverless good for?
Unpredictable or intermittent workloads
What is Aurora Multi-Master good for?
For continuous writes failover
What is Elasticache?
It is a managed Redis or Memcached
What is RedShift used for?
It is used for OLAP (Online Analytical Processing)
How does RedShift store data?
It is columnar storage, not row based
What does MPP stand for when talking about RedShift?
Massive Parallel Query Processing
How many nodes can RedShift have?
From 1 up to 128 nodes
How much space does each node have in RedShift?
128TB
What does the Leader node do in RedShift?
Its used for query planning and result aggregation
What are the Compute nodes in RedShift used for?
They’re used for performing queries and sending results to the Leader node
What is RedShift Spectrum?
Its used to perform queries directly on S3, no need to load
What is RedShift Enhanced VPC Routing used for?
It’s used for COPY/UNLOAD foes through VPC rather than the public internet to S3
How do you copy a RedShift snapshot to another AWS region?
You can configure RedShift to automatically copy snapshots of a cluster to another region
What is AWS Glue used for?
Its used for ETL (Extract, transform and load)
What is AWS Neptune?
It is a fully managed Graph database
What apps would use a graph db?
A social media platform etc
What has ElasticSearch been renamed to?
OpenSearch
What makes up the ELK stack?
ElasticSearch, Kibana and Logstash
