nerdexam
AmazonAmazon

DEA-C01 · Question #237

DEA-C01 Question #237: Real Exam Question with Answer & Explanation

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 la

Data Ingestion and Transformation

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

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

#AWS Glue#ETL#Data Transfer#Redshift to S3

Community Discussion

No community discussion yet for this question.

Full DEA-C01 PracticeBrowse All DEA-C01 Questions