RDS Flashcards

1
Q

RDS

A

Relational Database Service
Fully managed database service

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

Activities handled by AWS (4/5)

RDS

A
  • Provisioning
  • patching
  • backup
  • scalability
  • recovery

RDS

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

Availability

RDS

A

Supports multiple AZs

RDS

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

Network access

RDS

A

Launches into a VPC

RDS

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

horizontal scalability

RDS

A

Read replicas, where supported by platform

RDS

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

Available Platforms (4/7)

RDS

A

MySQL
PostgreSQL
MariaDB
Oracle DB
SQL Server
IBM DB2
Aurora

RDS

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

Aurora

RDS

A

Cloud DB built by AWS

RDS

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

Compatibility

RDS Aurora

A

MySQL
PostgreSQL

RDS Aurora

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

DMS

RDS

A

DB Migration Service
Migrate from onprem DB to AWS

RDS

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

Migration options (2)

RDS DMS

A

Onetime
Continual

RDS DMS

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

Cost basis

RDS DMS

A

Pay per compute

RDS DMS

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

vertical scaling

RDS Scalability

A

add resources

RDS Scalability

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

storage autoscaling

RDS Scalability

A

RDS detects if storage is low automatically expands it

RDS Scalability

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

maximum storage threshold

RDS storage autoscaling

A

customizable limit for DB storage

RDS storage autoscaling

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

conditions that prompt automatic scaling (3)

RDS storage autoscaling

A
  • free storage <10%
  • low storage for 5 minutes
  • 6 hours since last change

RDS storage autoscaling

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

which DB engines support

RDS storage autoscaling

A

all of them

RDS storage autoscaling

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

read replica

RDS

A

DB copy that services read requests

RDS

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

replica limit

RDS read replica

A

15

RDS read replica

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

replica placement options (3)

RDS read replica

A
  • in AZ
  • cross AZ
  • cross region

RDS read replica

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

syncronization type (2)

RDS read replica

A
  • asynchronous
  • reads are eventually consistent

RDS read replica

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

how to set application to use replicas

RDS read replica

A

write connection string to include replicas

RDS read replica

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

use case

RDS read replica

A

reporting application uses replica instead of taxing main DB

RDS read replica

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

AZ cost benefit

RDS read replica

A

cross AZ traffic does not incur fees

RDS read replica

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

multi AZ option

RDS read replica

A

may set up replicas as multi AZ for DR

RDS read replica

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

RDS multi AZ

RDS

A

hot standby DB instance

RDS

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

synchronization type (2)

RDS multi AZ

A
  • synchronous
  • changes replicate immediately

RDS multi AZ

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

how application connections are handled (2)

RDS multi AZ

A
  • one DNS name
  • auto failover in case of master DB outage

RDS multi AZ

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

difference compared to replica

RDS multi AZ

A

not used for scaling

RDS multi AZ

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

RDS Custom

RDS

A

Managed DB with access to DB and OS customizations

RDS

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

Used for DB engines (2)

RDS Custom

A
  • Oracle
  • Microsoft SQL Server

RDS Custom

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

provides

RDS Custom

A

full admin access

RDS Custom

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

Use (3)

RDS Custom

A
  • configure settings
  • install patches
  • enable native DB features

RDS Custom

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

steps to use (3)

RDS Custom

A
  1. de-activate authentication mode
  2. take DB snapshot
  3. connect using SSH or SSM

RDS Custom

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

automated BU (2)

RDS BU

A
  • Daily full
  • transaction logs every 5 minutes

RDS BU

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

what point in times can automated BU restore

RDS BU

A

may restore any point from oldest BU to 5 minutes

RDS BU

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

automated BU retention options (2)

RDS BU

A
  • 1 to 35 days
  • disabled

RDS BU

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

manual db snapshot

RDS BU

A

triggered by user

RDS BU

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

manual snapshot benefit

RDS BU

A

no retention time limit

RDS BU

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

cost benefit of manual snaphot

RDS BU

A

cheaper than storing a database offline

RDS BU

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

Restore MySQL to new database

RDS BU

A
  1. Create BU for onprem or cloud MySQL DB
  2. save to S3
  3. Restore to RDS

RDS BU

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

RDS restore option

RDS BU

A

Restore RDS / Aurora backup to new database

RDS BU

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

at-rest encryption

RDS Aurora security

A

DB master and replicas encrypted using AWS KMS

RDS Aurora security

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

how to encrypt unencrypted DB (2)

RDS Aurora security

A
  1. create DB snapshot
  2. restore snapshot as encrypted

RDS Aurora security

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

in-flight encryption

RDS Aurora security

A

TLS available using AWS TLS root certs

RDS Aurora security

45
Q

IAM authentication

RDS Aurora security

A

use role to manage access

RDS Aurora security

46
Q

Security groups

RDS Aurora security

A

control network access

RDS Aurora security

47
Q

audit logs

RDS Aurora security

A

logs can be enabled and sent to CloudWatch

RDS Aurora security

48
Q

RDS (Aurora) proxy

RDS

A

pools app connections and share DB connections

RDS

49
Q

general benefit

RDS (Aurora) proxy

A

improves DB efficiency by reducing resources used on DBs

RDS (Aurora) proxy

50
Q

features (4)

RDS (Aurora) proxy

A
  • fully managed
  • serverless
  • autoscaling
  • multi-AZ highly available

RDS (Aurora) proxy

51
Q

failover benefit

RDS (Aurora) proxy

A

reduced failover time

RDS (Aurora) proxy

52
Q

app dev benefit

RDS (Aurora) proxy

A

no code changes required

RDS (Aurora) proxy

53
Q

security

RDS (Aurora) proxy

A

enforce IAM only authentication

RDS (Aurora) proxy

54
Q

where is proxy accessible

RDS (Aurora) proxy

A

only available on private AWS network

RDS (Aurora) proxy

55
Q

Relational Database Service
Fully managed database service

A

RDS

56
Q
  • Provisioning
  • patching
  • backup
  • scalability
  • recovery

RDS

A

Activities handled by AWS (4/5)

RDS

57
Q

Supports multiple AZs

RDS

A

Availability

RDS

58
Q

Launches into a VPC

RDS

A

Network access

RDS

59
Q

Read replicas, where supported by platform

RDS

A

horizontal scalability

RDS

60
Q

MySQL
PostgreSQL
MariaDB
Oracle DB
SQL Server
IBM DB2
Aurora

RDS

A

Available Platforms (4/7)

RDS

61
Q

Cloud DB built by AWS

RDS

A

Aurora

RDS

62
Q

MySQL
PostgreSQL

RDS Aurora

A

Compatibility

RDS Aurora

63
Q

DB Migration Service
Migrate from onprem DB to AWS

RDS

A

DMS

RDS

64
Q

Onetime
Continual

RDS DMS

A

Migration options (2)

RDS DMS

65
Q

Pay per compute

RDS DMS

A

Cost basis

RDS DMS

66
Q

add resources

RDS Scalability

A

vertical scaling

RDS Scalability

67
Q

RDS detects if storage is low automatically expands it

RDS Scalability

A

storage autoscaling

RDS Scalability

68
Q

customizable limit for DB storage

RDS storage autoscaling

A

maximum storage threshold

RDS storage autoscaling

69
Q
  • free storage <10%
  • low storage for 5 minutes
  • 6 hours since last change

RDS storage autoscaling

A

conditions that prompt automatic scaling (3)

RDS storage autoscaling

70
Q

all of them

RDS storage autoscaling

A

which DB engines support

RDS storage autoscaling

71
Q

DB copy that services read requests

RDS

A

read replica

RDS

72
Q

15

RDS read replica

A

replica limit

RDS read replica

73
Q
  • in AZ
  • cross AZ
  • cross region

RDS read replica

A

replica placement options (3)

RDS read replica

74
Q
  • asynchronous
  • reads are eventually consistent

RDS read replica

A

syncronization type (2)

RDS read replica

75
Q

write connection string to include replicas

RDS read replica

A

how to set application to use replicas

RDS read replica

76
Q

reporting application uses replica instead of taxing main DB

RDS read replica

A

use case

RDS read replica

77
Q

cross AZ traffic does not incur fees

RDS read replica

A

AZ cost benefit

RDS read replica

78
Q

may set up replicas as multi AZ for DR

RDS read replica

A

multi AZ option

RDS read replica

79
Q

hot standby DB instance

RDS

A

RDS multi AZ

RDS

80
Q
  • synchronous
  • changes replicate immediately

RDS multi AZ

A

synchronization type (2)

RDS multi AZ

81
Q
  • one DNS name
  • auto failover in case of master DB outage

RDS multi AZ

A

how application connections are handled (2)

RDS multi AZ

82
Q

not used for scaling

RDS multi AZ

A

difference compared to replica

RDS multi AZ

83
Q

Managed DB with access to DB and OS customizations

RDS

A

RDS Custom

RDS

84
Q
  • Oracle
  • Microsoft SQL Server

RDS Custom

A

Used for DB engines (2)

RDS Custom

85
Q

full admin access

RDS Custom

A

feature provided by RDS Custom

RDS Custom

86
Q
  • configure settings
  • install patches
  • enable native DB features

RDS Custom

A

Use (3)

RDS Custom

87
Q
  1. de-activate authentication mode
  2. take DB snapshot
  3. connect using SSH or SSM

RDS Custom

A

steps to use

RDS Custom

88
Q
  • Daily full
  • transaction logs every 5 minutes

RDS BU

A

automated BU (2)

RDS BU

89
Q

may restore any point from oldest BU to 5 minutes

RDS BU

A

automated BU restore

RDS BU

90
Q
  • 1 to 35 days
  • disabled

RDS BU

A

automated BU retention options (2)

RDS BU

91
Q

triggered by user

RDS BU

A

manual db snapshot

RDS BU

92
Q

no retention time limit

RDS BU

A

manual snapshot benefit

RDS BU

93
Q

cheaper than storing a database offline

RDS BU

A

cost benefit of manual snaphot

RDS BU

94
Q
  1. Create BU for onprem or cloud MySQL DB
  2. save to S3
  3. Restore to RDS

RDS BU

A

Restore MySQL to new database

RDS BU

95
Q

Restore RDS / Aurora backup to new database

RDS BU

A

RDS restore option

RDS BU

96
Q

DB master and replicas encrypted using AWS KMS

RDS Aurora security

A

at-rest encryption

RDS Aurora security

97
Q
  1. create DB snapshot
  2. restore snapshot as encrypted

RDS Aurora security

A

how to encyrpt unencrypted DB (2)

RDS Aurora security

98
Q

TLS available using AWS TLS root certs

RDS Aurora security

A

in-flight encryption

RDS Aurora security

99
Q

use role to manage access

RDS Aurora security

A

IAM authentication

RDS Aurora security

100
Q

control network access

RDS Aurora security

A

Security groups

RDS Aurora security

101
Q

logs can be enabled and sent to CloudWatch

RDS Aurora security

A

audit logs

RDS Aurora security

102
Q

pools app connections and share DB connections

RDS

A

RDS (Aurora) proxy

RDS

103
Q

improves DB efficiency by reducing resources used on DBs

RDS (Aurora) proxy

A

general benefit

RDS (Aurora) proxy

104
Q
  • fully managed
  • serverless
  • autoscaling
  • multi-AZ highly available

RDS (Aurora) proxy

A

features (4)

RDS (Aurora) proxy

105
Q

reduced failover time

RDS (Aurora) proxy

A

failover benefit

RDS (Aurora) proxy

106
Q

no code changes required

RDS (Aurora) proxy

A

app dev benefit

RDS (Aurora) proxy

107
Q

enforce IAM only authentication

RDS (Aurora) proxy

A

security

RDS (Aurora) proxy

108
Q

only available on private AWS network

RDS (Aurora) proxy

A

where is proxy accessible

RDS (Aurora) proxy