DAS-C01 · Question #8
A retail company is building its data warehouse solution using Amazon Redshift. As a part of that effort, the company is loading hundreds of files into the fact table created in its Amazon Redshift cl
Sign in or unlock DAS-C01 to reveal the answer and full explanation for question #8. The question stem and answer options stay visible for context.
Question
A retail company is building its data warehouse solution using Amazon Redshift. As a part of that effort, the company is loading hundreds of files into the fact table created in its Amazon Redshift cluster. The company wants the solution to achieve the highest throughput and optimally use cluster resources when loading data into the company's fact table. How should the company meet these requirements?
Options
- AUse multiple COPY commands to load the data into the Amazon Redshift cluster.
- BUse S3DistCp to load multiple files into the Hadoop Distributed File System (HDFS) and use an
- CUse LOAD commands equal to the number of Amazon Redshift cluster nodes and load the data
- DUse a single COPY command to load the data into the Amazon Redshift cluster.
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.