QuestionQ27

VerifiedData Operations and Support

A company is developing an analytics solution. The solution uses Amazon S3 for data lake storage and Amazon Redshift as a data warehouse. The company wants to use Amazon Redshift Spectrum to query data stored in Amazon S3.

Which actions will deliver the FASTEST queries?

Choose two
Explanation

Columnar file formats, such as Apache Parquet, allow Redshift Spectrum to scan only the needed columns, reducing data transfer and scanning. Partitioning data by the most common query predicates lets Spectrum prune partitions that cannot satisfy a filter, reducing the amount of data read from Amazon S3.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!