Amazon Exam DAS-C01 Topic 7 Question 88 Discussion

Actual exam question for Amazon's DAS-C01 exam

Question #: 88
Topic #: 7

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 Annelle at Mar 21, 2024, 12:16 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Broderick

7 days ago

I'm feeling a bit lost on this one. All these options sound like they could work, but I'm not sure which one is the 'most accelerate' solution. Maybe I should just guess and hope for the best?

upvoted 0 times

...

Yuki

8 days ago

Option D sounds interesting, with the idea of sharding the files based on the DISTKEY columns. That could potentially improve the performance, but I'm not sure how easy it would be to implement. I might need to do some research on Redshift's data distribution strategies.

upvoted 0 times

...

Virgina

9 days ago

Hmm, this is a tricky one. I think the key is figuring out how to optimize the COPY process, but I'm not sure which approach is the best. I'm leaning towards option B, as splitting the files to match the number of slices in the Redshift cluster seems like it could help distribute the load.

upvoted 0 times

...

Josephine

10 days ago

I'm not sure about this question. The options seem a bit technical, and I'm not confident in my understanding of Amazon Redshift and COPY commands. I'll have to read through them carefully.

upvoted 0 times

...