Amazon Exam DAS-C01 Topic 2 Question 82 Discussion

Actual exam question for Amazon's DAS-C01 exam

Question #: 82
Topic #: 2

A company is building an analytical solution that includes Amazon S3 as data lake storage and Amazon Redshift for data warehousing. The company wants to use Amazon Redshift Spectrum to query the data that is stored in Amazon S3.

Which steps should the company take to improve performance when the company uses Amazon Redshift Spectrum to query the S3 data files? (Select THREE )

Use gzip compression with individual file sizes of 1-5 GB

AUse a columnar storage file format

BPartition the data based on the most common query predicates

CSplit the data into KB-sized files.

DKeep all files about the same size.

EUse file formats that are not splittable

Show Suggested Answer

Suggested Answer: B, C, D

by Elli at Nov 21, 2023, 01:28 AM

Limited Time Offer

25%

Off

Get Premium DAS-C01 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Blair

2 days ago

Good points, everyone. But I'm not sure about the whole 'KB-sized files' thing. That seems a bit overkill, don't you think? 1-5 GB seems like a good sweet spot.

upvoted 0 times

...

Kati

3 days ago

You guys are on the right track. But I also think we should use gzip compression to reduce the file sizes. Smaller files will be faster to scan.

upvoted 0 times

...

Aleisha

4 days ago

I agree, the columnar storage format is crucial for efficient querying. And partitioning the data based on the most common predicates will help Redshift Spectrum retrieve the relevant data quickly.

upvoted 0 times

...

Robt

5 days ago

Hmm, this question seems to be testing our understanding of how to optimize performance when using Amazon Redshift Spectrum. I think the key here is to use columnar storage file formats, partition the data, and keep the file sizes consistent.

upvoted 0 times

...