Section 9 AWS Fundamentals: RDS + Aurora + Elasticache Flashcards
AWS database engines supported
Postgres
MySQL
MariaDB
Oracle
MS SQL server
IBM DB2
Aurora
True or False. RDS has storage auto scaling
True
When does RDS storage auto scaling kick in?
Free storage is less than 10% of allocated storage
Low storage lasts for 5 minutes
6 hours have passed since last modification
Where can RDS read replicas be deployed
Within same AZ
Across az’s
Cross region
What is the limit on RDS read replicas
15
In RDS replicas, replication uses what type of SYNC?
ASYNC
What does ASYNC mean in RDS replicas?
Eventually cosistent
True or False. Read replicas can be promoted to their own DB
True
Read replicas are used for what type of statements
Select(read)
FOR RDS read replicas, this traffic is free
Within the same region
Can read replicas be setup as multi AZ for DR
Yes
Changing an RDS database from single AZ to Multi AZ
Don’t need to stop the DB
Clicking modify and enable multi AZ
Which database engines can RDS custom be used with
Managed oracle
MS SQL Server
What does RDS custom provide
access to underlying database
OS access
Access EC2 instance with SSH
What is recommended to do before any customization in RDS custom?
De-activate automation mode
DB snapshot
AWS Aurora DBs work with which DB engines?
Postgres
MySQL
AWS Aurora starts and ends at what storage amounts
Increments of 10gb up to 128tb
How many read replicas can Aurora have
15
In aurora how many masters are there
1
Does aurora have cross region replication
Yes
In Aurora db cluster what are the two endpoints?
Writer
Reader
In Aurora db cluster what is the writer endpoint for?
Pointing to the master
In Aurora db cluster what is the reader endpoint for?
Connects automatically to all the load balanced read replicas
What endpoint is typically not used when creating custom endpoints?
reader endpoint
Under what scenario would you want to use Aurora Serverless
unpredictable workloads
infrequent workloads
What type of Aurora is good for disaster recovery
Global
Typical cross region replication takes how much time in Aurora Global
less than 1 second
Which2 services are supported by Aurora ML
Sagemaker
Comprehend
Use cases for Aurora ML
Fraud detection
ads targeting
sentiment analysis
product recommendations
If you plan on stopping an RDS database for a long time how can you save money?
Create a snapshot of the database and delete the original database
RDS automated full backups occur how frequently?
daily
Manual RDS snapsots have how long of a retention?
No time limit
With Aurora backups how long back can you restore from
1 to 35 days
Can Aurora backups be disabled?
No
You can restore this DB from and S3 bucket
MySQL RDS
MySQL Aurora
Which backup utility must you use to restore a MySQL Aurora DB from S3
Percona XtraBackup
With this aws service you can create a new Aurora DB cluster from an existing one
Aurora Database cloning
Aurora Database Cloning uses what protocol to transfer data
copy-on-write
With RDS and Aurora what types of encryption are used
At-rest
In-flight
What IAM auth can RDS and Aurora use to connect to your database
IAM roles
How can you control network access to your RDS or Aurora DB
security groups
Which database type has SSH
RDS custom
What RDS capability can be used to reduce stress on database resources
RDS proxy
What RDS capability can be used to reduce failover times?
RDS Proxy
How can you force IAM auth to RDS dbs
RDS proxy
Are RDS proxies public or private
Private
This DB solution can reduce load on a db for read intensive workloads
ElastiCache
Two versions of ElastiCache
Redis
Memcached
3 kinds of patterns for loading data into ElastiCache
Lazy loading
Write Through
Session Store
What is a use case for ElastiCache with Redis?
Gaming leaderboards
What function within Redis guarantees both uniqueness and element ordering?
Redis Sorted Sets
