RDS, Aurora & ElastiCache

Question 1

managed DB service for DB using SQL as a query language. Allows you to create databases in the cloud that are managed by AWS

Answer 1

Relational Database Service (RDS)

Question 2

Using continuous backups to restore DB to a specific timestamp

Answer 2

Point in Time Restore

Question 3

Used by RDS for improved read performance. Up to 15 Within AZ, Cross AZ or Cross Region

Answer 3

Read Replicas

Question 4

Increase storage on your RDS DB instance dynamically, useful for applications with unpredictable workloads

Answer 4

RDS Storage Auto Scaling

Question 5

Type of replication done on read replicas

Answer 5

Asynchronous

Question 6

Only SQL statements allowed on read replicas

Answer 6

SELECT (read)

Question 7

Type of replication done in RDS Multi AZ

Answer 7

Synchronous

Question 8

Used for failover in case of loss of AZ, loss of
network, instance or storage failure

Answer 8

RDS Multi AZ

Question 9

Can you access the underlying DB within RDS?

Answer 9

No

Question 10

Does the RDS DB need to be stopped in order to migrate from a single AZ to Multi-AZ?

Answer 10

No

Question 11

Managed Oracle and Microsoft SQL Server Database with OS and
database customization

Answer 11

RDS Custom

Question 12

With RDS Custom can you access the underlying EC2 Instance?

Answer 12

Yes, using SSH or Session Manager

Question 13

Highly Available “AWS cloud optimized” DB and claims 5x performance improvement over MySQL on RDS, over 3x the performance of Postgres on RDS

Answer 13

Aurora

Question 14

Are Postgres and MySQL both supported as Aurora DB?

Answer 14

Yes

Question 15

Amount of replicas Aurora can have

Answer 15

15

Question 16

Does Aurora support Cross Region Replication?

Answer 16

Yes

Question 17

mechanism to abstract connections within Aurora for load-balancing and rerouting connections when some DB instances aren’t available

Answer 17

Endpoints

Question 18

provides load-balancing support for read-only connections to the DB cluster

Answer 18

Reader endpoint

Question 19

Feature of Aurora where every node has read/write capabilities

Answer 19

Aurora Multi-Master

Question 20

Automated database instantiation and auto-scaling based on actual usage

Answer 20

Aurora Serverless

Question 21

add ML-based predictions to your applications via SQL for fraud detection, ads targeting, sentiment analysis, product recommendations

Answer 21

Aurora Machine Learning

Question 22

Aurora Machine Learning supported services

Answer 22

Sagemaker and Comprehend

Question 23

Useful to create a “staging” database from a “production” database without impacting the production database.

Answer 23

Aurora Database Cloning

Question 24

Aurora and REDS use this for at-rest encryption

Answer 24

KMS

Question 25

Control Network access to your RDS / Aurora DB

Answer 25

Security Groups

Question 26

In-flight encryption of RDS & Aurora

Answer 26

TLS

Question 27

Allows apps to pool and share DB connections established with the database reducing the stress on database resources

Answer 27

Amazon RDS Proxy

Question 28

Used for managed Redis or Memcached

Answer 28

ElastiCache

Question 29

In-memory databases with really high performance, low latency

Answer 29

Cache

Question 30

Helps makes in-memory DB stateless and reduce load off of databases for read-intensive workloads

Answer 30

ElastiCache

Question 31

Multi-node for partitioning of data (sharding) in in-memory DB

Answer 31

Elasticache for Memcached

Question 32

Multi AZ with Auto-Failover along with Read Replicas to scale reads and have high availability

Answer 32

Elasticache for Redis