What sort of storage does Amazon Redshift use for database tables?

You have been asked to build a database warehouse using Amazon Redshift. You know a little about it, including that it is a SQL data warehouse solution, and uses industry standard ODBC and JDBCconnections and PostgreSQL drivers.

However you are not sure about what sort of storage it uses for database tables.

What sort of storage does Amazon Redshift use for database tables?
A .  InnoDB Tables
B .  NDB data storage
C .  Columnar data storage
D .  NDB CLUSTER Storage

Answer: C

Explanation:

Amazon Redshift achieves efficient storage and optimum query performance through a combination of massively parallel processing, columnar data storage, and very efficient, targeted data compression encoding schemes.

Columnar storage for database tables is an important factor in optimizing analytic query performance because it drastically reduces the overall disk I/O requirements and reduces the amount of data you need to load from disk.

Reference: http://docs.aws.amazon.com/redshift/latest/dg/c_columnar_storage_disk_mem_mgmnt.html

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments