DataBase Flashcards
Keyword “NFS” (or storage gateway) + no code changes + highly available + durability (posix compliant)
EFS
Storage which allow concurrent access ? (2)
S3 and EFS
Storage which allow strong consistency ? (3)
DynamoDB, EFS, RDS
Which storage provides strong Read-after-write consistency (most up-to-date data) ?
RDS
concurrent access + strong data consistency + file locking + Shared File System + Directories permission
EFS
What happens when RDS failure ?
RDS performs an automatic failover to the standby DB instance
Whith which type of DataBase IAM database authentication works ? (auth token not password) (3)
MariaDB, Mysql and Postgresql
how to enhance RDS performance ? (2)
Read replica + larger instance types
OLAP database + analytical queries involving complex calculations + data warehouse + columnar storage
Redshift
Which DB allows you to directly run SQL queries against exabytes of unstructured data in Amazon S3. No loading or transformation is required.
Redshift Spectrum
designed for globally distributed applications, allowing a single XXX database to span multiple AWS regions.
What is XXX ?
Aurora Global DB
What type of endpoint support DynamoDB and S3 ?
gateway endpoint (not interface)
built-in security + continuous backups + automated multi-Region replication + in-memory caching + Fast and predictable performance with consistent low latency + Possible to enable auto-scaling ?
DynamoDB
Fully managed + flexible schema + automatic scaling with no downtime + data in chunks
DynamoDB
Lowest latency data retrieval + highest scalability (50 ms latency + increasing exponentially)
DynamoDB
When to use snwomobile vs snowball ?
To migrate large datasets of 10PB or more in a single location, you should use Snowmobile (or snowball edge).
For datasets less than 10PB or distributed in multiple locations, you should use Snowball.
Mulit AZ vs Read replica, which is async and which is sync ?
Multi AZ : sync and highly durable
Read replica : async and highly scalable
Mulit AZ vs Read replica
AZ and region ?
multi AZ : always span two AZ in one region
read replica : can be within an AZ, cross AZ or cross region
Mulit AZ vs Read replica, failover ?
Multi AZ : automatic failover to standby when a problem is detected
Read replica : can be manually promoted to a standalone db instance
OLAP database
Redshift