DEA-C01 · Question #143
DEA-C01 Question #143: Real Exam Question with Answer & Explanation
Sign in or unlock DEA-C01 to reveal the answer and full explanation for question #143. The question stem and answer options stay visible for context.
Question
A company is using Amazon Redshift to build a data warehouse solution. The company is loading hundreds of files into a fact table that is in a Redshift cluster. The company wants the data warehouse solution to achieve the greatest possible throughput. The solution must use cluster resources optimally when the company loads data into the fact table. Which solution will meet these requirements?
Options
- AUse multiple COPY commands to load the data into the Redshift cluster.
- BUse S3DistCp to load multiple files into Hadoop Distributed File System (HDFS). Use an HDFS
- CUse a number of INSERT statements equal to the number of Redshift cluster nodes. Load the
- DUse a single COPY command to load the data into the Redshift cluster.
Unlock DEA-C01 to see the answer
You've previewed enough free DEA-C01 questions. Unlock DEA-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.