AWS Fundamentals: RDS + Aurora + Elasticache Flashcards

1
Q

What does RDS stand for?

A

Relational Database Service

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

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

A

What is RDS

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

RDS is mainly used for what?

A

Disaster Recovery

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

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

A

Query Language

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Using RDS, can you SSH into your instances?

A

No

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

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

A

RDS - Storage Auto Scaling

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What is RDS - Storage Auto Scaling good for?

A

Applications with unpredictable workloads

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Read replicas are only for (blank) statements

A

SELECT (means read)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Up to how many read replicas can you have?

A

5

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

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

A

Within AZ
Cross AZ
Cross Region

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

If the replication is ASYNC, what does that mean?

A

Reads are eventually consistent

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

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

A

Goes from one AZ to another

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

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

A

No

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

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

A

Yes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

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

A

Click on “modify” for the database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

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

A

No

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

What does it mean to encrypt?

A

Encoding of information.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

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

A

Encryption

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

How would you encrypt the master & read replicas?

A

AWS KMS - AES-256 encryption

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

What does TDE stand for?

A

Transparent Data Encryption

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

IAM database authentication only works with what? (2)

A

MySQL & PostgreSQL

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

Auth token has a lifetime of what?

A

15 minutes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

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

A

Snapshot
Copy snapshot as encrypted
Create DB from snapshot

24
Q

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

A

Aurora

25
Q

Writer Endpoint

A

Pointing to the master

26
Q

Reader Endpoint

A

Connection Load Balancing

27
Q

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

A

5/MySQL

3/PostgresSQL

28
Q

Aurora security is the exact same as (blank) security

A

RDS

29
Q

You return the state of an Aurora cluster to a specific point in time.

What feature in Aurora is this called

A

Backtracking

30
Q

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?

A

Global database

31
Q

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?

A

Machine Learning

32
Q

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

What Aurora feature is this?

A

Serverless

33
Q

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?

A

Custom endpoint

34
Q

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

A

Multi-Master

35
Q

Using Elasticache involves heavy application (blank)

A

Code changes

36
Q

What is the point of Elasticache?

A

To get managed Redis or Memcached

37
Q
  • 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)

A

Redis

38
Q
  • 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)

A

Memcached

39
Q

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

A

Memcached

40
Q

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

A

Redis

41
Q

All caches in Elasticache does NOT support what?

A

IAM Authentication

42
Q

What is the main use case for Redis?

A

Gaming Leaderboards

43
Q

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

A

Lazy loading

44
Q
FTP
SSH
SFTP
HTTP
HTTPS
A

important port

45
Q
PostgreSQL
MySQL
Oracle RDS
MSSQL Server
MariaDB
Aurora
A

RDS Databases ports

46
Q

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

A

Multi AZ

47
Q

What two features help scaling reads?

A

Elasticache & RDS Read Replicas

48
Q

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

A

Multi AZ

49
Q

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

A

Storing session data in Elasticache

50
Q

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

A

Aurora Global Database

51
Q

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

A

Redis Auth

52
Q

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.

A

Database Authentication

53
Q

Read Replicas uses (blank) replication

A

Asynchronous

54
Q

Multi AZ uses (blank) Replication

A

Synchronous

55
Q

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

A

15