RDS Flashcards

1
Q

Which relational databases does RDS support?

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

OLTP vs OLAP?

A
  • OLTP
  • Online Transaction Processing
  • Simple queries like insert, get
  • This is basically what RDS is
  • OLAP
  • Online Analytics Processing
  • Used for business intelligence and big data
  • More complex queries
  • Redshift
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Which are the two types of backup for RDS?

A
  • Automated
  • Retention period is 1 to 35 days
  • Takes a full daily snapshot, and also stores transaction logs throughout the day
  • Recovery: AWS chooses the most recent daily backup, then apply transaction logs relevant to that day
  • You can recover to any point in time down to a second (within the retention period)
  • Enabled by default
  • Stored in S3, free storage equal to the size of your database
  • Backups are taken within a defined window, during which you may experience elevated latency
  • Is deleted when your database is deleted
  • Snapshot
  • Taken manually/ user initiated
  • Stored even after your database has been deleted
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

When you restore either an Automatic Backup or manual Snapshot, will the restored version of the database have a new DNS endpoint?

A

Yes. It will be a new RDS instance with a new DNS endpoint.

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

Which database types supports encryption at rest?

A
  • All of them

* (MariaDB, Oracle, PostgreSQL, SQL Server, Aurora, MySQL)

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

How does an encrypted RDS instance effect backups, snapshots and Read Replicas?

A

Once your RDS instance is encrypted, the data stored at rest in the underlying storage is encrypted, as are its automated backups, snapshots, and read replicas.

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

How do you encrypt an existing RDS instance?

A
  • Create a snapshot of the instance
  • Make a copy of the snapshot, and encrypt the copy
  • Deploy a new RDS instance from the encrypted copy
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What AWS service is used for encryption at rest of RDS instances?

A

KMS (Key Management Service)

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

Which of the RDS types has support for Multi-AZ?

A
  • All of them
  • Aurora is per default spread across multiple Availability Zones
  • For the others you have to turn it on
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

How many Read replicas can you, per default, have per RDS instance?

A

5

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

You can have a Read Replica that have Multi-AZ.

A

True

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

For which of the RDS types is Read Replicas supported?

A

All of them.

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

Name one requirement for having Read Replicas.

A
  • You must have automatic backups turned on
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Can you create Read Replicas of Multi-AZ source databases?

A

Yes.

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

You can promote a Read Replica to its own database.

A

True, but it will break the replication.

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

It is possible to have a Read replica in another Region.

A

True.

17
Q

A Read Replica can have encryption at rest even if the primary database doesn’t have it.

A

True.