DEA-C01 · Question #237
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…
The correct answer is B. Create an AWS Glue job to connect to the Redshift data warehouse. Configure the AWS Glue job. An AWS Glue job can connect to your Amazon Redshift cluster and execute the UNLOAD command to export the specified vendor data directly into the vendor's S3 bucket. Scheduling the Glue job to run weekly requires minimal operational effort, and UNLOAD is optimized for exporting…
Question
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?
Options
- ACreate an AWS Lambda function to connect to the Redshift data warehouse. Configure the
- BCreate an AWS Glue job to connect to the Redshift data warehouse. Configure the AWS Glue job
- CUse the Amazon Redshift data sharing feature. Set the vendor's S3 bucket as the destination.
- DConfigure Amazon Redshift Spectrum to use the vendor's S3 bucket a destination, Enable data
How the community answered
(58 responses)- A9% (5)
- B72% (42)
- C3% (2)
- D16% (9)
Explanation
An AWS Glue job can connect to your Amazon Redshift cluster and execute the UNLOAD command to export the specified vendor data directly into the vendor's S3 bucket. Scheduling the Glue job to run weekly requires minimal operational effort, and UNLOAD is optimized for exporting large result sets efficiently.
Topics
Community Discussion
No community discussion yet for this question.