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

Exam question from Amazon's AWS Certified Data Engineer - Associate DEA-C01

Question #: 227
Topic #: 1

[All AWS Certified Data Engineer - Associate DEA-C01 Questions]

A company uses Amazon Redshift as a data warehouse solution. One of the datasets that the company stores in Amazon Redshift contains data for a vendor.

Recently, the vendor asked the company to transfer the vendor’s data into the vendor’s Amazon S3 bucket once each week.

Which solution will meet this requirement?

A. Create an AWS Lambda function to connect to the Redshift data warehouse. Configure the Lambda function to use the Redshift COPY command to copy the required data to the vendor’s S3 bucket on a schedule.
B. Create an AWS Glue job to connect to the Redshift data warehouse. Configure the AWS Glue job to use the Redshift UNLOAD command to load the required data to the vendor’s S3 bucket on a schedule.
C. Use the Amazon Redshift data sharing feature. Set the vendor’s S3 bucket as the destination. Configure the source to be as a custom SQL query that selects the required data.
D. Configure Amazon Redshift Spectrum to use the vendor’s S3 bucket a destination, Enable data querying in both directions.

Show Suggested Answer

Suggested Answer: B 🗳️

by rdiaz at July 4, 2025, 4:45 a.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

Submit Cancel

rdiaz

1 month, 2 weeks ago

Selected Answer: B

Redshift’s UNLOAD command is used to export data from Redshift to Amazon S3 in an efficient, parallelized manner. • AWS Glue can be scheduled and orchestrated to automate the weekly data export. • This solution allows precise control of which data to extract and where to deliver it — in this case, the vendor’s S3 bucket. • You can securely configure cross-account access if the vendor’s S3 bucket is in another AWS account.

upvoted 1 times

...