Databases Flashcards
Databases
RDS Supports 6 engines, what are they?
SQL Server, Postgres, Oracle, MySQL, MariaDB & Aurora
Databases
RDS Multi-AZ is used to improve….
performance, scalability, availability…
Availability
Used for DR only,
Databases
RDS Read Replicas are used to improve
performance, scalability, availability…
Performance & Scaling
Databases
Aurora can use one of two DB engines
what are they?
MySql & Postgres
Databases
What RDS Service is good for intermittent workloads?
Aurora Serverless
An on demand DB Service and automatically boots and shuts down.
Databases
Which DB service supports non-relational DB’s
DynamoDB
has both eventual & strongly consistent modes of opperation
Databases
What service can be used to improve the performance of DynamoDB
DynamoDB Accelerator (DAX)
uses an in memory cache
Databases
What service can ensure ACID operations in DynamoDB
DynamoDB Transactions
Databases
What service provides and FIFO stream of DynamoDB table changes
DynamoDB Streams
changes stores for 24hrs
Databases
Fully managed, multi master, multi region DynamoDB instance with sub second latancy
DynamoDB Global Tables
Streams must be enabled first
Databases
AWS Service for MongoDB databases
DocumentDB
migrations via DMS
Databases
Big Data, NoSQL DB for distributed computing using Cassandra
Keyspaces
Databases
AWS Managed Graph DB
Neptune
Databases
AWS managed Ledger DB
AWS QLDB
immutable to ensure history
Databases
What DB can be used to ensure history of changes is preserved
AWS QLDB