Databases Flashcards

1
Q

What are the 6 databases available in RDS?

A
  1. PostreSQL
  2. MS SQL Server
  3. Oracle
  4. MariaDB
  5. MySQL
  6. AWS Aurora (MySQL / PostgreSQL Emulation)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What happens in an AWS outage assuming you have a standby database? Is manual intervention required?

A
  • AWS changes the CNAME from primary to backup DB
  • Intervention is not needed
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is the use case for setting up multi-AZ database? What can you not to against the backup database in another region?

A
  • Failover and/or Disaster recovery (Not to scale the performance)
  • You cant run queries against the backup database
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What are the variations on RDS read replicas?

A
  • Standard
  • Multi-AZ
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Are read replicas Asynchronous or Synchronous

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

Can a read replica be promoted to be a primary database? What implications are there?

A

Yes, but it breaks the replication.

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

What is the main use case for read replicas?

A
  • Scaling (for read heavy loads) not Disaster Recovery
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What must be enabled to create read replicas?

A

Automatic backup

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

How many read replicas can you have on an RDS DB

A

5

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

Which database management systems can Aurora emulate?

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

How big is an Aurora DB? By how much does it scale? What is the max size?

A
  • 10GB to start
  • Increases automatically in 10GB increments
  • Up to 128TB
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

How many vCPUs can Aurora use? How much RAM can it use?

A
  • up to 96vcpus
  • up to 768 GB of RAM
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

How many copies of your data are kept when using AWS Aurora

A
  • 2 Per AZ
  • Minimum of 3 AZ
  • Minimum 6 copies
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

How many copies of data in an aurora database can be lost not affecting performance?

A

2

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

What types of replicas are available with Aurora? How many Read replicas are available for each?

A
  • Aurora - 15 RRs
  • Aurora MySQL - 5 RR
  • Aurora PostgreSQL - 5 RR
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

How do aurora backups work?

A
  • Aurora is automatically backed up with no impact to performance.
  • Database snapshots can be taken, with no performance impact, these snapshots can be shared with other accounts.
17
Q

Whats the use case for AWS Aurora Serverless?

A
  • Great for spikey or unpredicatable workloads
  • Only scales on when needed.
  • Scales up and down as needed
18
Q

How is Dynamo DB Stored?

A
  • SSD Storage
  • Spread across 3 datacenters (AZs)
  • Encrypted at rest
19
Q

What is DAX

A
  • Dynamo DB Accelerator, managed, highly available in-memory cache
  • Decreases request time to microseconds
  • Developers don’t need to manage it - App speaks directly to DAX
  • 10x performance improvement
20
Q

How is Dynamo DB secured?

A
  • Encrypted at rest
  • Accessed via policies and roles
21
Q

What are DynamoDB streams?

A
  • Time ordered flow of transactions from DynamoDB
  • Has its own endpoint
  • up to 24 hours of retention
22
Q

What are use cases for Dynamo DB transactions?

A
  • Financial transactions
  • Gaming
23
Q

What about Dynamo DB backup and recovery?

A
  • Can enable backups in the same region. they don’t impact performance.
  • Point in time recovery is available but must be enabled.
24
Q

What is a use case for using Dynamo DB Global Tables?

What technology in DynamoDB is required to use this?

A
  • Replicating data from one table to another in real-time
  • Globally distributed applications
  • Global Tables is based on DynamoDB streams.
25
Q

If you have a multi-AZ backup of your RDS DB

  1. Where are backups taken from?
  2. Are updates and maintenance updates applied to the backup DB?
A
  1. Backups are taken from the secondary DB
  2. Maintenance patches are applied to the backup
26
Q

Are RDS Multi AZ Deployments Synchronous or Asynchronous?

A

Synchronous

27
Q

How much will DynamoDB scale?

A
  • up to 10 trillion requests per day
  • up to 20 million requests per second
  • Petabytes of storage
28
Q

What is an Aurora Endpoint used for?

A

Aurora exists in a cluster, each of which has an endpoint. you connect to the cluster. the endpoint abstracts this.

Using endpoints, you can map each connection to the appropriate instance or group of instances based on your use case.

29
Q

Which AWS DB solutions allow you to store web application state data (key, value)

A
  • Elasticache (Redis)
  • DynamoDB
30
Q

What would you use for a global RDS solution with aggressive recovery?

A

Aurora Global Database

31
Q

How would you capture data changes in Aurora when a row is deleted?

A

Invoke a Lambda function from aurora with a native function or stored procedure.

32
Q

How would you configure a connection from EC2 to an RDS DB using an authentication token? which DBs does this apply to?

A

User IAM DB Authentication

IAM database authentication works with MariaDB, MySQL and PostgreSQL