RDS Flashcards

1
Q

Backups are automatically ___ in RDS

A

Enabled

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

Limit of ____ Read Replicas in RDS

A

5

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

T/F: There is no cost when data goes from one AZ to another

A

False: There is network cost when data goes from one AZ to another

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

RDS Multi AZ (DR) has ___ replication

A

Sync

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

Transparent Data Encryption is available for which DBs?

A

Oracle & SQL Server

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

For RDS, encryption has to be defined at ___

A

Launch time

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

RDS If the master is not encrypted, the read replica ___

A

Cannot be encrypted

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

At rest encryption for Master and Read Replicas with ___

A

AWS KMS

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

Enforce SSL in flight encryption for which DBs

A

Postgres & MySQL

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

How to encrypt an un-encrypted RDS DB

A
  • Create a snapshot of the un-encrypted DB
  • Copy the snapshot and enable encryption for the snapshot
  • Restore DB from the encrypted snapshot
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

IAM-based authentication can be used to login into which DBs

A

Postgres & MySQL

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

Version of Aurora good for infrequent, intermittent or unpredictable workloads

A

Aurora Serverless

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

ElastiCache is to get managed ___

A

Redis or Memcached

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q
Pro
-Only requested data is cached
Con
-Cache miss penalty results in 3 round trips
-Stale data
A

Lazy Loading/Cache-Aside/Lazy Population

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

Pro
-Data in cache is never stale
Con
-Missing Data until it is added/updated in the DB
-Cache Churn a lot of the data will never be read

A

Write Through

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

Cache Eviction can occur in three ways

A
  • Delete the item explicitly
  • Item is evicted because memory is full & not recently used
  • Set an item TTL
17
Q

RDS dbs are usually deployed within ___ subnet

A

Private

18
Q

Aurora: Up to ___ replicas

A

15

19
Q

ElasticCache - MultiAZ w/ auto-failover

A

Redis

20
Q

ElasticCache - Multi-node for partitioning of data, non-persistent

A

Memcache