Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

DVA > RDS - Relational Database Service > Flashcards

RDS - Relational Database Service Flashcards

1
Q

What is RDS

A

Relational Database Service is a managed DB service for DB that use SQL and allows you to create databases in the cloud that are managed by AWS

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

What are the databases managed by RDS?

A
  • Postgres
  • MySQL
  • MariaDB
  • Oracle
  • Microsoft SQL Server
  • Aurora (AWS Proprietary database)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What can’t you do on RDS that can do if you would have a DB deployed on EC2?

A

you can’t SSH into your instance

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

What you must do to have backups in RDS?

A

nothing, backups are automatically enabled in RDS

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

What does allow you to do the RDS automated backups?

A

to restore to any point in time from oldest backup to 5 minutes ago

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

How frequently does run a RDS full backup?

A

daily during the maintenance windows

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

how frequently are transaction logs backed up on RDS?

A

every 5 minutes

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

how many days are automatic logs retained by default in RDS?

A

7 days, can be increased to 35

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

what are RDS DB snapshots?

A

they are backups manually triggered by the user

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

how many days are db snapshots retained by default in RDS?

A

for as long as you want

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

What is the max number of read replicas allowed in RDS?

A

up to 5

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

Are RDS read replicas cross AZ or cross regions?

A

yes to all

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

how does happen replication on RDS?

A

async

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

If something is wrong what can you do with your RDS replica?

A

you can promote it to be a master DB

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

What needs to be done on application side to leverage RDS replicas?

A

applications must update the connection string

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

what SQL statements are allowed on RDS replicas?

A

just selects

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

What is a common use of RDS replicas?

A

to run a reporting application to run some analytics

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

What happens when data goes from 1 AZ to another?

A

there is a cost involved

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

What can you do to reduce cost of RDS replicas?

A

you can have them in the same AZ

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

What is RDS multi AZ for disaster recovery setup?

A

RDS uses read replicas and the replication is sync

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

What is provided by RDS multi-AZ for disaster recovery setup?

A

one DNS name and automatic failover to standby

22
Q

How and when can you encrypt data at rest on RDS?

A

with AWS KMS - AES-256 only at launch time

23
Q

how can you encrypt a read replica of a master RDS that is not encrypted?

A

you can’t

24
Q

What RDS DBs can use TDE (Transparent Data Encryption)?

A

Oracle and SQL Server

25
Q

What can you use to encrypt RDS data in-flight?

A

SSL certificates

26
Q

How are RDS snapshots in terms of encryption?

A

snapshots preserve encryption status

27
Q

What can you do when you copy a RDS snapshot?

A

you can encrypt it

28
Q

How can you encrypt an un-encrypted RDS DB?

A

1-create a snapshot
2-copy and enable encryption
3-restore the DB from the encrypted snapshot
4-migrate applications to the new DB and delete the old one

29
Q

What does RDS use to secure network?

A

leverages SGs as EC2 instances controling which IP / SG can communicate with RDS

30
Q

Within what is usually RDS deployed?

A

within a private subnet

31
Q

What does help to control who can manage RDS?

A

IAM policies through RDS API

32
Q

How can you login into RDS DBs?

A

using traditional username and password

33
Q

What RDS DBs allow to authenticate using IAM-based auth?

A

Postgre and MySQL

34
Q

What you need to use IAM-based auth on RDS?

A

an auth token obtained through IAM and RDS API calls

35
Q

What is the lifetime of RDS IAM auth tokens?

A

15 minutes

36
Q

What are RDS parameter groups?

A

it allows you to manage your DB engine configuration by associating your DB instances

37
Q

Is Aurora open source?

A

no, it is a proprietary technology from AWS

38
Q

Which DBs are supported as Aurora DB?

A

Postgres and MySQL

39
Q

How is Aurora performance compared to RDS MySQL and Posgre?

A

5x MySQL

3x Postgre

40
Q

How does increment Aurora storage?

A

automatically in increments of 10GB, up to 64TB

41
Q

How many replicas can you use on Aurora?

A

Aurora can have 15 replicas while MySQL has 5, and the replication process is faster (sub 10 ms replica lag)

42
Q

What are the main features of Aurora?

A
  • Automatic fail-over
  • Backup and Recovery
  • Isolation and security
  • Industry compliance
  • Push-button scaling
  • Automated Patching with Zero Downtime
  • Advanced Monitoring
  • Routine Maintenance
  • Backtrack: restore data at any point of time without using backups
43
Q

What is provided by Aurora cluster?

A

A writer endpoint to master and a Reader endpoint for replicas

44
Q

What is provided by Aurora cluster Reader Endpoint?

A

A connection load balancing

45
Q

Can you scale on Aurora?

A

you can auto scale replicas

46
Q

What is Aurora Serverless?

A

is an on-demand, auto-scaling configuration based on actual usage for Amazon Aurora

47
Q

What is good for Aurora Serverless?

A

for infrequent, intermittent or unpredictable workloads

48
Q

As what can you infer an Online Transactional Processing (OLTP)?

A

as a Relational Database

49
Q

How can you set auto scaling in RDS?

A

you can’t auto scale RDS

50
Q

What is Global Aurora?

A

It allows a single Aurora database to span multiple AWS regions, with fast replication to enable low-latency global reads and disaster recovery from region-wide outages

51
Q

What is provided by Global Aurora?

A

o 1 Primary Region (read / write)
o Up to 5 secondary (read-only) regions, replication lag is less than 1 second
o Up to 16 Read Replicas per secondary region
o Helps for decreasing latency
o Promoting another region (for disaster recovery) has an RTO of < 1 minute

DVA (61 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions