Amazon
DAS-C01 · Question #26
A large financial company is running its ETL process. Part of this process is to move data from Amazon S3 into an Amazon Redshift cluster. The company wants to use the most cost-efficient method to lo
Sign in or unlock DAS-C01 to reveal the answer and full explanation for question #26. The question stem and answer options stay visible for context.
Processing
Question
A large financial company is running its ETL process. Part of this process is to move data from Amazon S3 into an Amazon Redshift cluster. The company wants to use the most cost-efficient method to load the dataset into Amazon Redshift. Which combination of steps would meet these requirements? (Choose two.)
Options
- AUse the COPY command with the manifest file to load data into Amazon Redshift.
- BUse S3DistCp to load files into Amazon Redshift.
- CUse temporary staging tables during the loading process.
- DUse the UNLOAD command to upload data into Amazon Redshift.
- EUse Amazon Redshift Spectrum to query files from Amazon S3.
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
#Redshift Data Loading#ETL Best Practices#Cost Optimization#Amazon S3