Databases - RedShift Flashcards

1
Q

Is RedShift fully managed?

A

Yes

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

RedShift configuration

A

Single node (160 GB), multi-node

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

Multi node consists of

A

Leader node, compute node

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

Leader node

A

manages client connections and receives queries

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

Compute node

A

store data and perform queries and computations. up to 128 compute nodes

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

Does RedShift organize data by rows or columns?

A

Columns, so improved performance

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

Redshift is fast because

A

Massively Parallel processing, advanced compression

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

RedShift pricing

A

compute node hours,backup, data transfer w/in a VPC

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

RedShift security

A

encrypted in transit (SSL), encrypted at rest (AES-256), redshift takes care of key management by default

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

Redshift availability

A

1 AZ, can restore snapshots to new AZs in case of outage

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