A company is loading hundreds of files into a fact table in an Amazon Redshift cluster and wants the highest possible load throughput while using cluster resources efficiently. Which loading strategy will best meet these goals?
Choose an answer
Tap an option to check your answer.
Correct answer: Use a single COPY command to load the data into the Redshift cluster..
Why this is the answer
A single COPY command is the most efficient way to load large amounts of data into Amazon Redshift. Redshift is designed to parallelize the COPY operation across all compute nodes, maximizing throughput. Using multiple COPY commands can introduce overhead and contention, potentially slowing down the overall load process. S3DistCp and HDFS are not directly relevant for loading data into Redshift; S3 is the preferred staging area. Using multiple INSERT statements is highly inefficient for bulk loading as each INSERT statement incurs significant overhead compared to the optimized COPY command.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed