AWS Fundamentals: RDS + Aurora + ElastiCache Flashcards

1
Q

What is Amazon RDS?

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

What are the advantage of using RDS versus deploying a DB on EC2?

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

What is RDS Storage Auto-Scaling and how does it work?

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

What are RDS Read Replicas?

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

Where can you create RDS Read Replicas (within AZ, cross AZ, cross region)?

A

All of them!

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

Is replication in RDS Read Replicas sync or async?

A

Async

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

Does an application have to be aware of read replicas in RDA?

A

Yes, it must update the connection string to leverage read replicas

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

What are some use cases for using Read Replicas in RDS?

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

What are the networking costs associated with Read Replicas in RDS?

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

What is RDS Multi-AZ (Disaster Recovery)?

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

Is RDS Multi-AZ sync or async?

A

Sync

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

What option is used for scaling in RDS?

A

Read Replicas

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

What option is used for disaster recovery in RDS?

A

Multi-AZ

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

Can Read Replicas be set-up as Multi-AZ for disaster recover purposes?

A

Yes!

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

How do you make an RDS database go from Single-AZ to Multi-AZ?

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

What is RDS Custom?

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

What is Amazon Aurora?

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

What database engines are compatible with Amazon Aurora?

A

MySQL and Postgres

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

How does high-availability and read scaling work in Amazon Aurora?

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

How do read/writes work in an Aurora cluster?

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

How does scalability work with Read Replicas in Amazon Aurora?

A

The client connects to a Reader Endpoint (helps with connection load balancing) and it connects to all the read replicas

Load balancing happens at the connection level, not the statement level

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

What are the main features of Amazon Aurora?

A
23
Q

What is Backtrack in Amazon Aurora

A

It is used to restore data at any point in time without using backups (up to 72 hours)

24
Q

How does Replica Auto-Scaling work in Amazon Aurora?

A
25
Q

How do Custom Endpoints work in Amazon Aurora?

A
26
Q

What is Amazon Aurora Serverless?

A
27
Q

What is Aurora Multi-Master?

A
28
Q

What is Global Aurora?

A
29
Q

What is the typical amount of time it takes to replicate data using Cross-Region in Aurora?

A

1 second

30
Q

What is Aurora’s integration with Machine Learning in AWS ML services?

A
31
Q

What AWS ML services does Aurora integrate with?

A
  • Amazon SageMaker (use with any ML model)
  • Amazon Comprehend (for sentiment analysis)
32
Q

What are the features of RDS Backups?

A
33
Q

What is the earliest backup available in RDS using Backups?

A

5 minutes ago

34
Q

What is a way to save money if you only use a database for a short period of time every month?

A

Instead of just stopping the database (which will still incur costs) take a snapshot of the database and restore it when you need it again

35
Q

What are the features of Aurora Backups?

A
36
Q

What are the RDS and Aurora Backup restore options?

A
37
Q

What is Aurora Database Cloning?

A
38
Q

What encryption options are available in RDS and Aurora?

A
39
Q

What security options are available in RDS and Aurora?

A
40
Q

What is Amazon RDS Proxy?

A
41
Q

What is a service that you can use to improve database efficiency by reducing the stress on RDS database resources and minimize open connections?

A

RDS Proxy

42
Q

What is a service that you can use to reduce RDS & Aurora failover by as much as 66%?

A

RDS Proxy

43
Q

How can you enforce IAM authentication for RDS databases and securely store IAM credentials in AWS Secrets Manager?

A

Use RDS Proxy

44
Q

Can you make an RDS Proxy publicly accessible?

A

No

45
Q

What is Amazon ElastiCache?

A
46
Q

ElastiCache Solution Architecture Diagram - DB Cache (example)

A
47
Q

ElastiCache Solution Architecture Diagram - User Session Store (example)

A
48
Q

What are the differences between Redis and Memcached in ElastiCache?

A
49
Q

If you need to cache Sets or Sorted Sets, what AWS service would you use?

A

ElastiCache with Redis

50
Q

If you need high-availability with a caching service what would you recommend?

A

ElastiCache with Redis

51
Q

What are the options for security in ElastiCache?

A
52
Q

What are some pattern (uses) for ElastiCache?

A
53
Q

What are use cases for Redis in ElastiCache?

A
54
Q

What are the most important database ports?

A