Deck 2 Flashcards
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
Redshift configuration
Starts with a single node (160GB)
Multi-node comprised of:
-Leader node (Client connection manager and receives queries)
-Compute node (stores data & performs quieries and computations). Up to 128 nodes.
Max size of provisioned IOPS drive for MySQL and Oracle RDS databases
6TB (minimum of 100GB)
What happens to the I/O operations while you take a database snapshot?
I/O operations to the database are suspended for the duration of the snapshot
Maximum provisioned IOPS capacity on an Oracle and MySQL RDS instance (using provisioned IOPS)
30,000
Can reserved instances be moved from one region to another?
No
Max RDS SQL Express DB size
10GB
Can I “force” a failover for any RDS instance that has Multi-AZ configured?
Yes
AWS support plans
Basic (included)
Developer - $49/month
Business - $100/month
Enterprise - Starts at $15k/month
Support plan critical response times
Basic - N/A
Developer -
Can reserved instances be moved to another AZ?
yes
