Amazon Exam DAS-C01 Topic 2 Question 90 Discussion

Actual exam question for Amazon's DAS-C01 exam

Question #: 90
Topic #: 2

A company uses Amazon EC2 instances to receive files from external vendors throughout each day. At the end of each day, the EC2 instances combine the files into a single file, perform gzip compression, and upload the single file to an Amazon S3 bucket. The total size of all the files is approximately 100 GB each day.

When the files are uploaded to Amazon S3, an AWS Batch job runs a COPY command to load the files into an Amazon Redshift cluster.

Which solution will MOST accelerate the COPY process?

AUpload the individual files to Amazon S3. Run the COPY command as soon as the files become available.

BSplit the files so that the number of files is equal to a multiple of the number of slices in the Redshift cluster. Compress and upload the files to Amazon S3. Run the COPY command on the files.

CSplit the files so that each file uses 50% of the free storage on each compute node in the Redshift cluster. Compress and upload the files to Amazon S3. Run the COPY command on the files.

Dpply sharding by breaking up the files so that the DISTKEY columns with the same values go to the same file. Compress and upload the sharded files to Amazon S3. Run the COPY command on the files.

Show Suggested Answer

Suggested Answer: B

by Meghan at Apr 25, 2024, 12:35 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Galen

10 months ago

I agree with User1, option D seems like a strategic approach to improve the COPY process by applying sharding.

upvoted 0 times

...

Gracia

10 months ago

I disagree, I believe option B would be more effective because splitting the files to match the number of slices in the Redshift cluster would optimize the COPY process.

upvoted 0 times

...