Database Flashcards
Aurora
Relational database (MySQL and PostgreSQL)
Fast and scalable.
Allows replicas for read scaling within and across Regions.
Offers automated backups.
Relational
Read scaling across Regions.
Automated backups.
Aurora
DynamoDB
NoSQL (non-relational) database
DocumentDB
NoSQL database
Supports document data structures.
Serverless querying of data in Amazon S3 using SQL-like parameters
Athena
Uses SQL to analyze structured data in data warehouses.
Redshift
Redshift
Data Analysis
Warehouses
SQL
OLAP
Amazon RDS
RDS is typically used as an online transaction processing (OLTP) database rather than an OLAP database.
Relational database (SQL)
data is structured and well-formed
Migrating existing applications
Relational database (SQL)
OLTP
data is structured and well-formed
Migrating existing applications
Amazon RDS
Binary large objects (BLOBs)
Static websites
S3
Name/value pair data
Unpredictable data structure
No-SQL
DynamoDB
Allows full control over instance and database.
Use when preferred DB not available under RDS.
Database on EC2
in-memory db caching
improves performance for read requests
placed in front of database
ElastiCache
ElastiCache
in-memory db caching
improves performance for read requests
placed in front of database
a data warehouse that is used for performing analytics on data
RedShift
Which DB solution would you use when migrating an application to the cloud?
Custom DB hosted on EC2
sub-millisecond latency
used for real-time applications
open-source, widely compatible
Elasticache
a cloud big data / hadoop platform that can be queried using SQL
EMR
A company is interested in moving its on-premises NoSQL database into the AWS Cloud.
Which AWS service should the company use to replace their existing database?
DynamoDB
What is the difference between QLDB and Managed Blockchain?
Unlike managed blockchain, QLDB is CENTRALIZED financial ledger while Managed Blockchain is DE-CENTRALIZED.
DB for Ethereum and Hyperledger.
Managed blockchain
managed ledger database that provides transparent, immutable, and cryptographically verifiable transactions
QLDB
EMR
big data
hadoop framework
queried using SQL
Which two benefits can a company gain by deploying a relational database on Amazon RDS instead of Amazon EC2?
Automated backups.
Software Patching.
