Deck 2 Flashcards
(34 cards)
Relational Databases - OLTP
Mysql SQL Postgres Oracle Aurora
Non-Relational - NoSQL
MongoDB
DynamoDB
Data Warehousing - OLAP (Online Analytics)
Redshift
Elasticache
Redis
Memcache
Difference between DynamoDB and MongoDB
DynamoDB cannot have embedded data structures
The max backup retention period for a database
35 days
Amazon DB that is associated with OLTP
RDS
NoSQL AmazonDB
DynamoDB
Amazon OLAP DB (Analytics)
Redshift
In memory caching DB
Memcached
What can done with RDS database online
Add storage Update the instance class password
What happens when you restore a DB
A new DB is created
Limitation of a SQL instance
Cannot be resized with out exporting and importing to another DB
Is there a default database with a SQL instance
No
New Amazon MySQL compatible database
Aurora
Aurora DB size and CPU and Memory
DB starts at 10GB increments to 64TB
Up to 32 vCPUs
Up to 244GB RAM
Running copies of an Aurora DB and in how many AZ
2 copies with a minimum of 3 AZs for 6 total copies
How many copies of an Aurora DB can be lost without affecting writes
2
Aurora can lose how many copies and still be read only?
3
DynamoDB data availability zones
Stored in 3 different geographically located data centers. This is automatic and unchangeable unlike RDS.
DynamoDB consistency options
Eventually consistent reads (default)
Strong consistent reads
DynamoDB storage and other limitations
Based on SSD
Cannot have nested key value pairs like MongoDB
Massively parallel process (MPP) data warehouse services
Redshift
Columnar data storage
Redshift
