Amazon Exam DAS-C01 Topic 3 Question 84 Discussion

Actual exam question for Amazon's DAS-C01 exam

Question #: 84
Topic #: 3

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 Ryan at Dec 23, 2023, 02:05 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Celia

8 months ago

Good point. But I'm not sure about the file size recommendation. Keeping all files about the same size, between 1-5 GB, sounds more efficient than splitting them into KB-sized files.

upvoted 0 times

Kenneth

8 months ago

D) Keep all files about the same size

upvoted 0 times

...

Kayleigh

8 months ago

B) Partition the data based on the most common query predicates

upvoted 0 times

...

Rozella

8 months ago

A) Use a columnar storage file format

upvoted 0 times

...

Leonida

8 months ago

Absolutely, and partitioning the data based on common query predicates is also a great idea. That way, Redshift Spectrum can quickly identify the relevant partitions and avoid scanning unnecessary data.

upvoted 0 times

...

Juliana

8 months ago

I agree, this is a complex issue. From what I understand, we should definitely use a columnar storage file format like Parquet or ORC. That will help with efficient data access and processing.

upvoted 0 times

...

Robt

8 months ago

Hmm, this is a tricky question. We need to consider a few factors to improve Redshift Spectrum performance when querying S3 data files.

upvoted 0 times

...