AWS Certified Data Engineer – Associate (DEA-C01) — Question 214

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?

Answer options

• 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.

Correct answer: B

Explanation

The correct answer, B, is appropriate because AWS Glue can efficiently extract data from Amazon Redshift using the UNLOAD command, facilitating the scheduled transfer to S3. Option A is incorrect as the COPY command is not suitable for transferring data to S3; it is used for loading data into Redshift. Option C is incorrect because data sharing does not directly support moving data to S3. Option D is also not suitable since Redshift Spectrum is designed for querying data, not for transferring it to S3.