ExamTopics Logo
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

Exam AWS Certified Data Engineer - Associate DEA-C01 All Questions

View all questions & answers for the AWS Certified Data Engineer - Associate DEA-C01 exam
Go to Exam

Exam AWS Certified Data Engineer - Associate DEA-C01 topic 1 question 133 discussion

Exam question from Amazon's AWS Certified Data Engineer - Associate DEA-C01
Question #: 133
Topic #: 1
[All AWS Certified Data Engineer - Associate DEA-C01 Questions]

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?

  • A. Use multiple COPY commands to load the data into the Redshift cluster.
  • B. Use S3DistCp to load multiple files into Hadoop Distributed File System (HDFS). Use an HDFS connector to ingest the data into the Redshift cluster.
  • C. Use a number of INSERT statements equal to the number of Redshift cluster nodes. Load the data in parallel into each node.
  • D. Use a single COPY command to load the data into the Redshift cluster.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by canace at Aug. 4, 2024, 11:54 p.m.
Disclaimers:
  • - ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
  • - Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
canace
Highly Voted 9 months ago
D? https://docs.aws.amazon.com/redshift/latest/dg/t_Loading-data-from-S3.html
upvoted 5 times
...
cas_tori
Most Recent 8 months, 3 weeks ago
Selected Answer: D
this is D
upvoted 1 times
...
antun3ra
9 months ago
Selected Answer: D
A single COPY command automatically parallelizes the load operation across all nodes in the Redshift cluster. This ensures optimal use of cluster resources.
upvoted 3 times
...
phkhadse
9 months ago
A - Using multiple COPY commands allows parallel loading of data, which maximizes throughput.
upvoted 2 times
...
Shanmahi
9 months ago
Selected Answer: D
Agree with canace; Redshift's copy command uses MPP architecture to read and load in parallel from files into DWH.
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago