Redshift Flashcards

1
Q

What is redshift?

A

A data warehousing solution.

Petabyte scale databasing.

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

Can redshift be easily scaled?

A

Yes

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

Red shift is a ……-based database

A

Column

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

Redshift has a unique way of routing data around a VPC without exposing it to the internet. It is called…

A

Redshift Enhanced VPC routing

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

Redshift is best for what kind of queries?

A

Analytical

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

Does redshift allow for cross region snapshots?

A

Yes

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

Redshift will provide better performance. If you specify…

A

Sort keys
Distribution keys
Column encodings

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

What is Redshift Spectrum?

A

A query engine for redshift

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

When loading data into an empty redshift table. redshift automatically samples the data and selects…:

A

The most appropriate compression scheme.

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