Amazon redshift Flashcards

1
Q

reshift: Redshift allows

A

Columnar database - this type of database returns data by columns rather than whole rows. It has better performance for aggregating large sets of data, perfect for analytical querying.

Sharding - Redshift supports data sharding, that is, partitioning the tables across different servers for better performance.

Scalability - With everything running on the cloud, Redshift clusters can be easily up/down sized as needed.

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

redshift: Redshift only accepts

A

flat text files, while hadoop accepts any data type

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