Databases and Analytics Flashcards
Relational Database
Relations between tables in a database
Language for relational databases
SQL
NoSQL DB Benefits
Flexible
Scalable
High-performance
Highly functional
RDS acronym
Relational Database Service
What are key-value, Document, graph, in-memory, and search databases examples of?
NoSQL Databases
NoSQL DB’s purpose built for…
Specific data models with flexible schemas for modern apps
NoSQL data type
JSON
What database type can be nested?
NoSQL (JSON)
AWS managed DB benefits
Provisioning, HA, Scaling, Backup, restore, OS patching, monitoring, alerting
AWS service for Oracle
RDS
RDS
Managed DB service using SQL
AWS service for Postgres
RDS
AWS service for MariaDB
RDS
AWS service for Aurora
RDS
Can you SSH into RDS instances
no
DB types supported by Aurora (2)
PostgreSQL
MySQL
Aurora DB max size
128TB
How much more does Aurora cost over RDS (percent)
20%
Which DB type is more cloud native (RDS or Aurora)?
Aurora
RDS Read Replica
Scale read workload
Max RDS read replicas
15
RDS Multi-AZ
Failover in case of AZ outage
How many failover AZ’s in RDS multi-AZ?
1
RDS Multi-Region
Read replicas in different regions
In-Memory Database service
ElastiCache
AWS service for Redis
ElastiCache
AWS service for Memcached
Elasticache
Benefit of ElastiCache
Relieve load from RDS
DynamoDB benefits
Fully managed HA with replication in 3 AZ
Which DB type is “serverless?”
DynamoDB
Low latency DB type
Dynamo DB
Dynamo DB Relational or NoSQL?
NoSQL
DynamoDB Accelorator (DAX)
In-memory cache for DynamoDB
DynamoDB Global Tables
Make DynamoDB accessible with low latency in multiple regions
Which DB type has Active-Active Replication
DynamoDB
Which table allows writing in Dynamo DB?
All of them
Redshift OLTP or OLAP
OLAP
DB with hourly load interval
Redshift
Database with columnar storage
Redshift
Database that has a data warehouse to do computation/analytics/visualization on datasets?
Redshift
BI Tools for Redshift (2)
Quicksight
Tableau
Amazon EMR acronym
Elastic MapReduce
EMU helps provision…
Hadoop clusters
DB for machine learning, web indexing, big data
EMR
Serverless query service for S3 analytics
Amazon Athena
Amazon Athena (SQL or NoSQL)
SQL
Database for BI for VPN flow logs, ELB logs, Cloudtrail Trails, etc…
Amazon Athena
Amazon Quicksight purpose
BI
Dashboards
Visualizations
DocumentDB (SQL or NoSQL)
NoSQL
DocumentDB is AWS version of…
MongoDB
DocumentDB max size
64TB
DocumentDB is similar to what other Amazon service?
Aurora
DocumentDB number of AZ’s
3
Neptune is
Graph DB
Neptune Graph DB use cases…
Social networking
Fraud detection
Recommendation engines
Amazon QLDB purpose
Review history of all changes to app data
Which DB type is similar to blockchain
QLDB
Immutable DB service
QLDB
QLDB central or decentralized
Central DB
Managed Blockchain central or decentralized
Decentralized
DB product for financial transactions
QLDB
Hyperledger Fabric or Ethereum Product…
Amazon Managed Blockchain
AWS Glue
Managed ETL service
ETL used for…
Prepare and transform data for analytics
DMS Acronym
Database Migration Service
Can DMS support migrating from one database type to another?
Yes (ex. Microsoft SQL to Oracle)
Key/Value Database product…
DynamoDB & DAX