AWS Certified Data Engineer - Associate DEA-C01 — Topic 1 Question 133

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?

Accepted Answer

Correct answer: D. The correct answer is D. Option D: Use a single COPY command to load the data into the Redshift cluster. Amazon Redshift is a managed petabyte-scale data warehouse for complex analytical queries.

AWS Certified Data Engineer - Associate DEA-C01 — Question 133