Exam DEA-C01 All QuestionsBrowse all questions from this exam
Go to Exam
Question 113

A company uses Amazon S3 as a data lake. The company sets up a data warehouse by using a multi-node Amazon Redshift cluster. The company organizes the data files in the data lake based on the data source of each data file.

The company loads all the data files into one table in the Redshift cluster by using a separate COPY command for each data file location. This approach takes a long time to load all the data files into the table. The company must increase the speed of the data ingestion. The company does not want to increase the cost of the process.

Which solution will meet these requirements?

    Correct Answer: D

    To increase the speed of data ingestion into an Amazon Redshift table, creating a manifest file that contains the data file locations and then using a COPY command to load these files is an effective solution. This approach allows you to load multiple data files with a single COPY command, optimizing the ingestion process without increasing costs. A manifest file helps Amazon Redshift understand where the data files are located and can ingest them in parallel, significantly speeding up the data loading process.

Discussion
HunkyBunkyOption: D

Only D makes sense https://docs.aws.amazon.com/redshift/latest/dg/c_best-practices-single-copy-command.html

androloginOption: D

D is the right answer based on the docs in this page https://docs.aws.amazon.com/redshift/latest/dg/c_best-practices-single-copy-command.html

Bmaster

D is good https://docs.aws.amazon.com/redshift/latest/dg/c_best-practices-single-copy-command.html https://docs.aws.amazon.com/redshift/latest/dg/loading-data-files-using-manifest.html