RDS Flashcards

1
Q

What are the 2 types of RDS backups? What is the big difference between them?

A
  • Automated Backups
  • Database Snapshots
  • Big difference is whether they are taken automatically vs. manually
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What do RDS Automated Backups allow you to do?

A

Automated backups allow you to recover your database to any point in time within a retention period

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

How long is the retention period for Automated Backups?

A

can be between 1 and 35 days

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

What do RDS automated backups store?

A
  • A full daily snapshot AND
  • transaction logs throughout the day
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

How do RDS Automated Backups do a recovery?

A

choose the most recently daily backup, and apply the transaction logs relevant to that day

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

How specific can the timing of an RDS Automated Backup recovery be?

A

You can do a point in time recovery, down to a second, within the retention period

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

Are RDS Automated Backups enabled by default?

A

Yes

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

Where are RDS Automated Backups stored?

A

in S3.

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

What is the pricing model for RDS Automated Backup storage?

A

Backups are stored in S3, and you get free storage space equal to the size of the DB

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

Why might enabling RDS Automated Backups result in a elevated latencies over a brief period of time?

A

During the backup window, storage I/O may be suspended while your data is being backed up, so you may get elevated latency.

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

After you delete the original RDS instance, are RDS automated backups deleted as well?

A

Yes

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

After you delete the original RDS instance, are DB snapshots deleted as well?

A

No

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

After restoring an RDS Automated Backup, is the restored version of the DB on the same DNS as the old DB?

A

No

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

After restoring an RDS Manual Snapshot, is the restored version of the DB on the same DNS as the old DB?

A

No

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

For what DB engines is RDS Encryption at Rest supported?

A

(All of them)

  • MySQL
  • Oracle
  • SQLServer
  • PostgreSQL
  • MariaDB
  • Aurora
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What does RDS Encryption at Rest use for encryption?

A

KMS

17
Q

Once your RDS instance is encrypted using RDS Encryption at Rest, are automated backups automatically encrypted as well?

A

Yes

18
Q

Once your RDS instance is encrypted using RDS Encryption at Rest, are read replicas automatically encrypted as well?

A

Yes

19
Q

Once your RDS instance is encrypted using RDS Encryption at Rest, are DB snapshots automatically encrypted as well?

A

Yes

20
Q

Does RDS Multi-AZ boost performance?

A

NO (that’s Read Replicas)

21
Q

What does RDS Multi-AZ do?

A
  • automatic, synchronous replication of your DB in another AZ
  • Automatic failover in case the primary instance goes down
22
Q

With what RDS DB engines does Multi-AZ work?

A

(All except Aurora)

  • SQLServer
  • Oracle
  • MySQLServer
  • PostgreSQL
  • MariaDB
23
Q

Assuming Multi-AZ is turned on, what is a way that you can force a failover for your RDS instance?

A

Reboot your RDS instance

24
Q

What type of replication is involved with RDS Read Replicas?

A

Asynchronous replication

25
Q

What is the primary difference between a primary instance and its read replica?

A

The read replica is read-only

26
Q

With what RDS DB engines are Read Replicas compatible?

A

(all except SQLServer)

  • MySQLServer
  • PostgreSQL
  • MariaDB
  • Oracle
  • Aurora
27
Q

Do you need to have automatic backups turned on in order to use read replicas?

A

Yes

28
Q

Can you have RDS Read Replicas of RDS Read Replicas?

A

Yes, but watch out for replication latency issues

29
Q

Does an RDS instance and its read replica share a DNS endpoint?

A

No, each read replica has its own DNS endpoint

30
Q

Can you have Multi-AZ RDS Read Replicas?

A

Yes

31
Q

Can you have RDS Read Replicas of RDS DBs that are sources for Multi-AZ?

A

Yes

32
Q

Can you turn a read replica into a “normal” database?

A

Yes, but this breaks replication

33
Q

Can you have an RDS Read Replica in a region that is different from the primary instance, assuming you are using Multi-AZ?

A

Yes

34
Q

Can you have an RDS Read Replica of an RDS instance which is not using multi-AZ?

A

Yes

35
Q

What are the two best ways to improve RDS performance?

A
  • Read Replicas
  • Elasticache
36
Q

In RDS, can you create a Read Replica in another region?

A

Depends on the underlying database format

(All except SQLServer are supported)

37
Q

RDS supports:

A

MariaDB

PostgreSQL

MySQL

SQLServer

Oracle

Aurora