AWS Database Flashcards
How many Database Types there is in AWS ?
4, RDS (OLTP), DynamoDB no SQL, RedShift OLAP, Elasticache
What RDS mean ?
Relational Database Service
What OLTP mean ?
Online Transaction Processing
What OLAP mean ?
Online Analytics processing
How many Databases services there is with RDS ?
6, SQL, MYSQL, PostrgreSQL, Aurora,MariaDB
How many Elasticache service there is ? what are they ?
2 Memcached, Redis
What is Multi AZ with RDS ?
Copy of RDS instance into different Zone, that would be failed over in case of outage.
What is Read Replica ?
Read copy only of the RDS instance, can be up to 5 replica.
Can we do Read Replica of Read Replica ?
Yes, but latency will get higher and higher
What is Aurora ?
Amazon Aurora is a relational database engine that combines the speed and reliability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. It delivers up to five times the throughput of standard MySQL and up to three times the throughput of standard PostgreSQL.
How many copies of Aurora there is ?
2 Copies in each AZ and minimum of 3 AZ so total 6 copies
How many copies of data need to be lost to impact Write and Read of Aurora Instance ?
2 for write, 3 for read.
How many types of Auraora replicas there is ?
2
What’s the dfifference between Auraora replicas and MySQL Read Replicas
MySQL read replicas are the same as the RDS one, Aurora one is up to 15 and read and write
What the difference between DynamoDB and RDS database on scaling point of view ?
DynamoDB is scaling up with push button, can be scaled on the fly while RDS need to be stop, copy and snapshot.
What storage is used for Dynamo DB ?
SSD
How is spread DynamoDB data ?
3 distinct data center
What the read/write mode of DynamoDB ?
Eventual Consisten READ (Default) or Strongly consistent READ (can send the write data back within a second).
What is RedShift For ?
Data whareousing ?
What the two configuration for RedShit ?
Single Node (160GB) or MultiNode(One Leader Node, and up to 128 compute node)
What is Elasticache for ?
To cache in MEM database.
What is the two open source engine supported by Elasticache
Memcached, Redis
In RDS, what is the maximum value I can set for my backup retention period?
35 days
Automated backups are enabled by default for a new DB Instance?
True
Amazon RDS does not currently support increasing storage on a ____ Db instance
SQL Server
In RDS what is the maximum size for a Microsoft SQL Server DB Instance with SQL Server Express edition?
10 GB
Can I “force” a failover for any RDS instance that has Multi-AZ configured?
Yes
For DynamoDB what are the 3 scenario where we want to enable Cross region replication ?
Live data migration
Easier Traffic management
Disaster Recovery
