DEA-C01 · Question #231
DEA-C01 Question #231: Real Exam Question with Answer & Explanation
Sign in or unlock DEA-C01 to reveal the answer and full explanation for question #231. The question stem and answer options stay visible for context.
Question
A company receives marketing campaign data from a vendor. The company ingests the data into an Amazon S3 bucket every 40 to 60 minutes. The data is in CSV format. File sizes are between 100 KB and 300 KB. A data engineer needs to set-up an extract, transform, and load (ETL) pipeline to upload the content of each file to Amazon Redshift. Which solution will meet these requirements with the LEAST operational overhead?
Options
- ACreate an AWS Lambda function that connects to Amazon Redshift and runs a COPY command.
- BCreate an Amazon Data Firehose stream. Configure the stream to use an AWS Lambda function
- CUse Amazon Redshift Spectrum to query the S3 bucket. Configure an AWS Glue Crawler for the
- DCreates an AWS Database Migration Service (AWS DMS) task. Specify an appropriate data
Unlock DEA-C01 to see the answer
You've previewed enough free DEA-C01 questions. Unlock DEA-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.