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
RDS multi AZ | RDS
hot standby DB instance | RDS
26
synchronization type (2) | RDS multi AZ
* synchronous * changes replicate immediately | RDS multi AZ
27
how application connections are handled (2) | RDS multi AZ
* one DNS name * auto failover in case of master DB outage | RDS multi AZ
28
difference compared to replica | RDS multi AZ
not used for scaling | RDS multi AZ
29
RDS Custom | RDS
Managed DB with access to DB and OS customizations | RDS
30
Used for DB engines (2) | RDS Custom
* Oracle * Microsoft SQL Server | RDS Custom
31
provides | RDS Custom
full admin access | RDS Custom
32
Use (3) | RDS Custom
* configure settings * install patches * enable native DB features | RDS Custom
33
steps to use (3) | RDS Custom
1. de-activate authentication mode 2. take DB snapshot 3. connect using SSH or SSM | RDS Custom
34
automated BU (2) | RDS BU
* Daily full * transaction logs every 5 minutes | RDS BU
35
what point in times can automated BU restore | RDS BU
may restore any point from oldest BU to 5 minutes | RDS BU
36
automated BU retention options (2) | RDS BU
* 1 to 35 days * disabled | RDS BU
37
manual db snapshot | RDS BU
triggered by user | RDS BU
38
manual snapshot benefit | RDS BU
no retention time limit | RDS BU
39
cost benefit of manual snaphot | RDS BU
cheaper than storing a database offline | RDS BU
40
Restore MySQL to new database (3 steps) | RDS BU
1. Create BU for onprem or cloud MySQL DB 2. save to S3 3. Restore to RDS | RDS BU
41
RDS restore option | RDS BU
Restore RDS / Aurora backup to new database | RDS BU
42
at-rest encryption | RDS Aurora security
DB master and replicas encrypted using AWS KMS | RDS Aurora security
43
how to encrypt unencrypted DB (2) | RDS Aurora security
1. create DB snapshot 2. restore snapshot as encrypted | RDS Aurora security
44
in-flight encryption | RDS Aurora security
TLS available using AWS TLS root certs | RDS Aurora security
45
IAM authentication | RDS Aurora security
use role to manage access | RDS Aurora security
46
Security groups | RDS Aurora security
control network access | RDS Aurora security
47
audit logs | RDS Aurora security
logs can be enabled and sent to CloudWatch | RDS Aurora security
48
RDS (Aurora) proxy | RDS
pools app connections and share DB connections | RDS
49
general benefit | RDS (Aurora) proxy
improves DB efficiency by reducing resources used on DBs | RDS (Aurora) proxy
50
features (4) | RDS (Aurora) proxy
* fully managed * serverless * autoscaling * multi-AZ highly available | RDS (Aurora) proxy
51
failover benefit | RDS (Aurora) proxy
reduced failover time | RDS (Aurora) proxy
52
app dev benefit | RDS (Aurora) proxy
no code changes required | RDS (Aurora) proxy
53
security | RDS (Aurora) proxy
enforce IAM only authentication | RDS (Aurora) proxy
54
where is proxy accessible | RDS (Aurora) proxy
only available on private AWS network | RDS (Aurora) proxy
55
Relational Database Service Fully managed database service
RDS
56
* Provisioning * patching * backup * scalability * recovery | RDS
Activities handled by AWS (4/5) | RDS
57
Supports multiple AZs | RDS
Availability | RDS
58
Launches into a VPC | RDS
Network access | RDS
59
Read replicas, where supported by platform | RDS
horizontal scalability | RDS
60
MySQL PostgreSQL MariaDB Oracle DB SQL Server IBM DB2 Aurora | RDS
Available Platforms (4/7) | RDS
61
Cloud DB built by AWS | RDS
Aurora | RDS
62
MySQL PostgreSQL | RDS Aurora
Compatibility | RDS Aurora
63
DB Migration Service Migrate from onprem DB to AWS | RDS
DMS | RDS
64
Onetime Continual | RDS DMS
Migration options (2) | RDS DMS
65
Pay per compute | RDS DMS
Cost basis | RDS DMS
66
add resources | RDS Scalability
vertical scaling | RDS Scalability
67
RDS detects if storage is low automatically expands it | RDS Scalability
storage autoscaling | RDS Scalability
68
customizable limit for DB storage | RDS storage autoscaling
maximum storage threshold | RDS storage autoscaling
69
* free storage <10% * low storage for 5 minutes * 6 hours since last change | RDS storage autoscaling
conditions that prompt automatic scaling (3) | RDS storage autoscaling
70
all of them support autoscaling | RDS storage autoscaling
which DB engines are supported | RDS storage autoscaling
71
DB copy that services read requests | RDS
read replica | RDS
72
15 | RDS read replica
replica limit | RDS read replica
73
* in AZ * cross AZ * cross region | RDS read replica
replica placement options (3) | RDS read replica
74
* asynchronous * reads are eventually consistent | RDS read replica
syncronization type (2) | RDS read replica
75
write connection string to include replicas | RDS read replica
how to set application to use replicas | RDS read replica
76
reporting application uses replica instead of taxing main DB | RDS read replica
use case | RDS read replica
77
cross AZ traffic does not incur fees | RDS read replica
AZ cost benefit | RDS read replica
78
may set up replicas as multi AZ for DR | RDS read replica
multi AZ option | RDS read replica
79
hot standby DB instance | RDS
RDS multi AZ | RDS
80
* synchronous * changes replicate immediately | RDS multi AZ
synchronization type (2) | RDS multi AZ
81
* one DNS name * auto failover in case of master DB outage | RDS multi AZ
how application connections are handled during DR event (2) | RDS multi AZ
82
not used for scaling | RDS multi AZ
difference compared to replica | RDS multi AZ
83
Managed DB with access to DB and OS customizations | RDS
RDS Custom | RDS
84
* Oracle * Microsoft SQL Server | RDS Custom
Used for DB engines (2) | RDS Custom
85
full admin access | RDS Custom
feature provided by RDS Custom | RDS Custom
86
* configure settings * install patches * enable native DB features | RDS Custom
Use (3) | RDS Custom
87
1. de-activate authentication mode 2. take DB snapshot 3. connect using SSH or SSM | RDS Custom
steps to use | RDS Custom
88
* Daily full * transaction logs every 5 minutes | RDS BU
automated BU (2) | RDS BU
89
may restore any point from oldest BU to 5 minutes | RDS BU
automated BU restore | RDS BU
90
* 1 to 35 days * disabled | RDS BU
automated BU retention options (2) | RDS BU
91
triggered by user | RDS BU
manual db snapshot | RDS BU
92
no retention time limit | RDS BU
manual snapshot benefit | RDS BU
93
cheaper than storing a database offline | RDS BU
cost benefit of manual snaphot | RDS BU
94
1. Create BU for onprem or cloud MySQL DB 2. save to S3 3. Restore to RDS | RDS BU
Restore MySQL to new database | RDS BU
95
Restore RDS / Aurora backup to new database | RDS BU
RDS restore option | RDS BU
96
DB master and replicas encrypted using AWS KMS | RDS Aurora security
at-rest encryption | RDS Aurora security
97
1. create DB snapshot 2. restore snapshot as encrypted | RDS Aurora security
how to encyrpt unencrypted DB (2) | RDS Aurora security
98
TLS available using AWS TLS root certs | RDS Aurora security
in-flight encryption | RDS Aurora security
99
use role to manage access | RDS Aurora security
IAM authentication | RDS Aurora security
100
control network access | RDS Aurora security
Security groups | RDS Aurora security
101
logs can be enabled and sent to CloudWatch | RDS Aurora security
audit logs | RDS Aurora security
102
pools app connections and share DB connections | RDS
RDS (Aurora) proxy | RDS
103
improves DB efficiency by reducing resources used on DBs | RDS (Aurora) proxy
general benefit | RDS (Aurora) proxy
104
* fully managed * serverless * autoscaling * multi-AZ highly available | RDS (Aurora) proxy
features (4) | RDS (Aurora) proxy
105
reduced failover time | RDS (Aurora) proxy
failover benefit | RDS (Aurora) proxy
106
no code changes required | RDS (Aurora) proxy
app dev benefit | RDS (Aurora) proxy
107
enforce IAM only authentication | RDS (Aurora) proxy
security | RDS (Aurora) proxy
108
only available on private AWS network | RDS (Aurora) proxy
where is proxy accessible | RDS (Aurora) proxy