Database Services Flashcards

1
Q

What are non-relational databases good for?

A

Applications that need to perform just a few well-defined queries and highly transactional applications

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

What are relational databases good for?

A

Performing complex analytics and generating reports against large data sets and ideal for reporting and analysis

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

What is Amazon Aurora?

A

It’s a relational proprietary database designed for RDS.

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

What is the only database type that can be used with BYOL (“bring your own license”)?

A

Oracle

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

What are the three instance classes you can choose from when deploying and RDS database?

A

Standard (2–96 vCPU, 8–384 GB memory)
- most applications will be good with standard

Memory optimized (4–128 vCPU, 122–3,904 GB memory)
- most demanding applications

Burst-able performance (2–8 vCPU, 1–32 GB memory)
- minimal performance requirements and best for test/dev applications

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

What are the three types of storage offered by RDS?

A

General purpose SSD

  • good enough for most databases
  • you can allocate between 20 GB and 32 TB
  • IOPS is determined by amount of storage
  • bursting

Provisioned IOPS SSD

  • you can specify the IOPS
  • up to 32TB
  • no bursting

Magnetic

  • only up to 4TB and 1000 IOPS
  • does not use EBS
  • used for legacy systems only
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What does scaling vertically mean?

A

It means choosing a more (or less) powerful instance type or selecting a different IOPS.

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

What are read-replicas?

A

Think “horizontal scaling.”

Basically, you can add more RDS instances that can perform read actions only.

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

How long will RDS keep automatic snapshots?

A

The default is 7 days, but you can customize that time to be anywhere from 1 to 35 days

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

What would be a good strategy if your Recovery Point Objective (RPO) was 5min or less?

A

Use multi-AZ and probably also snapshots

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

What are the three attribute types for DynamoDB?

A

Scalar

Set

Document (good for storing things like JSON objects)

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

How can DynamoDB use horizontal scaling to ensure consistent performance?

A

You can either manually or enable Autoscaling to adjust the RCU or WCU. Think “partitions” when it comes to DynamoDB and horizontal scaling.

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

What is RedShift?

A

Think “data warehouse.” RedShift can store up to 2PB!

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

What do you need to choose in order to spin up a new RDS?

A
Instance class (this defines the vCPU and memory)
Database engine
A type of storage (general purpose or IOPS SSD)
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What two databases is Amazon Aurora compatible with?

A

PostgreSQL

MySQL

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

What RDS feature can help you achieve a monthly availability of 99.95 percent?

A

Multi-AZ

17
Q

What is the minimum monthly availability for DynamoDB in a single region?

A

99.99%

18
Q

Which Redshift feature can analyze structured data stored in S3?

A

Redshift Spectrum