AWS Fundamentals: RDS + Aurora + Elasticache

Question 1

What does RDS stand for?

Answer 1

Relational Database Service

Question 2

A managed DB service for DB use SQL as a query language

Answer 2

What is RDS

Question 3

RDS is mainly used for what?

Answer 3

Disaster Recovery

Question 4

Any computer programming language that requests and retrieves data from a database management system (DBMS)

Answer 4

Query Language

Question 5

Using RDS, can you SSH into your instances?

Answer 5

No

Question 6

When RDS detects you are running out of free database storage, it scales automatically. What is this feature called?

Answer 6

RDS - Storage Auto Scaling

Question 7

What is RDS - Storage Auto Scaling good for?

Answer 7

Applications with unpredictable workloads

Question 8

Read replicas are only for (blank) statements

Answer 8

SELECT (means read)

Question 9

Up to how many read replicas can you have?

Answer 9

5

Question 10

What are the 3 different options for read replicas to scale?

Answer 10

Within AZ
Cross AZ
Cross Region

Question 11

If the replication is ASYNC, what does that mean?

Answer 11

Reads are eventually consistent

Question 12

In AWS for read replicas there’s a network cost when data does what?

Answer 12

Goes from one AZ to another

Question 13

For RDS Read Replicas within the same region, do you have a fee?

Answer 13

No

Question 14

Can Read Replicas be setup as Multi AZ for Disaster Recovery?

Answer 14

Yes

Question 15

How do you make a RDS DB go from single AZ to multi AZ?

Answer 15

Click on “modify” for the database

Question 16

If the master is not encrypted, can the read replicas be encrypted?

Answer 16

No

Question 17

What does it mean to encrypt?

Answer 17

Encoding of information.

Question 18

Used in a variety of online services to keep your data private & safe: from text messages and emails to banking details, cloud files and more

Answer 18

Encryption

Question 19

How would you encrypt the master & read replicas?

Answer 19

AWS KMS - AES-256 encryption

Question 20

What does TDE stand for?

Answer 20

Transparent Data Encryption

Question 21

IAM database authentication only works with what? (2)

Answer 21

MySQL & PostgreSQL

Question 22

Auth token has a lifetime of what?

Answer 22

15 minutes

Question 23

If your RDS DB is unencrypted, how would you encrypt it?

Answer 23

Snapshot
Copy snapshot as encrypted
Create DB from snapshot

Question 24

A fully managed relational database engine that’s compatible with MySQL & PostgreSQL

Answer 24

Aurora

Question 25

Writer Endpoint

Answer 25

Pointing to the master

Question 26

Reader Endpoint

Answer 26

Connection Load Balancing

Question 27

Aurora can deliver up to (blank) times the throughput of (blank) and up to (blank) times the throughput of (blank) w/o requiring changes to most of your existing applications

Answer 27

5/MySQL 3/PostgresSQL

Question 28

Aurora security is the exact same as (blank) security

Answer 28

RDS

Question 29

You return the state of an Aurora cluster to a specific point in time. What feature in Aurora is this called

Answer 29

Backtracking

Question 30

A single database that spans multiple AWS Regions, enabling low latency (blank) reads and disaster recovery from any Region-wide outage What Aurora feature is this?

Answer 30

Global database

Question 31

Provides simple, optimized, and secure integration between Aurora and AWS (blank) services without having to build custom integrations or move data around. What Aurora feature is this?

Answer 31

Machine Learning

Question 32

An on-demand, auto-scaling feature designed to be a cost-effective approach to running intermittent or unpredictable workloads What Aurora feature is this?

Answer 32

Serverless

Question 33

Represents a set of DB instances that you choose. When you connect to the (blank), Aurora performs load balancing and chooses one of the instances in the group to handle the connection. What Aurora feature is this?

Answer 33

Custom endpoint

Question 34

In case you want immediate failover for write node (you want HA for the writer node)

Answer 34

Multi-Master

Question 35

Using Elasticache involves heavy application (blank)

Answer 35

Code changes

Question 36

What is the point of Elasticache?

Answer 36

To get managed Redis or Memcached

Question 37

* Multi AZ with Auto-Failover * Read Replicas to scale reads and have high availability * Data durability using AOF persistence * Backup and restore features (High Availability, Backup, Read Replica)

Answer 37

Redis

Question 38

* Multi-node for partitioning of data (sharding) * No high availability (replication) * Non persistent * No backup and restore * Multi-threaded architecture (Can’t afford to lose data)

Answer 38

Memcached

Question 39

High performance, distributed memory object caching system, intended for use in speeding up dynamic web application

Answer 39

Memcached

Question 40

In-memory data structure store used as database, cache and message broker. Offers Multi-AZ with Auto-Failover and enhanced robustness

Answer 40

Redis

Question 41

All caches in Elasticache does NOT support what?

Answer 41

IAM Authentication

Question 42

What is the main use case for Redis?

Answer 42

Gaming Leaderboards

Question 43

A way to shorten the length of the critical rendering path, which translates into reduced page load times

Answer 43

Lazy loading

Question 44

``` FTP SSH SFTP HTTP HTTPS ```

Answer 44

important port

Question 45

``` PostgreSQL MySQL Oracle RDS MSSQL Server MariaDB Aurora ```

Answer 45

RDS Databases ports

Question 46

(Blank) helps when you plan a disaster recovery for an entire AZ going down.

Answer 46

Multi AZ

Question 47

What two features help scaling reads?

Answer 47

Elasticache & RDS Read Replicas

Question 48

(Blank) keeps the same connection string regardless of which database is up

Answer 48

Multi AZ

Question 49

A common pattern to ensuring different EC2 instances can retrieve your users state if needed

Answer 49

Storing session data in Elasticache

Question 50

(Blank) allows you to have an Aurora Replica in another AWS Region, with up to 5 secondary regions

Answer 50

Aurora Global Database

Question 51

How can you enhance the security of your Elasticache Redis Cluster by forcing users to enter a password when they connect?

Answer 51

Redis Auth

Question 52

The process or act of confirming that a user who is attempting to log in to a database is authorized to do so, and is only accorded the rights to perform activities that he or she has been authorized to do.

Answer 52

Database Authentication

Question 53

Read Replicas uses (blank) replication

Answer 53

Asynchronous

Question 54

Multi AZ uses (blank) Replication

Answer 54

Synchronous

Question 55

How many Aurora Read Replicas can you have in a single Aurora DB Cluster?

Answer 55

15