nerdexam
AmazonAmazon

DAS-C01 · Question #52

DAS-C01 Question #52: Real Exam Question with Answer & Explanation

Sign in or unlock DAS-C01 to reveal the answer and full explanation for question #52. The question stem and answer options stay visible for context.

Storage and Data Management

Question

A large company receives files from external parties in Amazon EC2 throughout the day. At the end of the day, the files are combined into a single file, compressed into a gzip file, and uploaded to Amazon S3. The total size of all the files is close to 100 GB daily. Once the files are uploaded to Amazon S3, an AWS Batch program executes a COPY command to load the files into an Amazon Redshift cluster. Which program modification will accelerate the COPY process?

Options

  • AUpload the individual files to Amazon S3 and run the COPY command as soon as the files
  • BSplit the number of files so they are equal to a multiple of the number of slices in the Amazon
  • CSplit the number of files so they are equal to a multiple of the number of compute nodes in the
  • DApply sharding by breaking up the files so the distkey columns with the same values go to the

Unlock DAS-C01 to see the answer

You've previewed enough free DAS-C01 questions. Unlock DAS-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#Amazon Redshift#Data Loading#COPY command#Performance Optimization
Full DAS-C01 PracticeBrowse All DAS-C01 Questions