DEA-C01 · Question #282
A company uses an Amazon S3 bucket to integrate multiple data sources into a central data lake. The company needs to perform multiple transformations and data cleaning processes on the data to make…
The correct answer is B. Use an AWS Glue Flex Job after normal business hours to process the previous day's data, apply. AWS Glue Flex Jobs provide discounted, off-hours batch ETL to transform S3 data, and Amazon Redshift Serverless offers on-demand SQL access during business hours without paying for idle clusters minimizing cost and operations.
Question
A company uses an Amazon S3 bucket to integrate multiple data sources into a central data lake. The company needs to perform multiple transformations and data cleaning processes on the data to make the data accessible to business partners. The company needs a solution that will give multiple business partners the ability to run SQL queries on the central data lake during normal business hours. Which solution will meet these requirements MOST cost-effectively?
Options
- AUse a provisioned Amazon EMR cluster after normal business hours to process the previous
- BUse an AWS Glue Flex Job after normal business hours to process the previous day's data, apply
- CUse an AWS Lambda function after normal business hours to process the previous day's data,
- DUse an AWS Glue Flex job after normal business hours to process the previous day's data, apply
How the community answered
(47 responses)- A4% (2)
- B68% (32)
- C11% (5)
- D17% (8)
Explanation
AWS Glue Flex Jobs provide discounted, off-hours batch ETL to transform S3 data, and Amazon Redshift Serverless offers on-demand SQL access during business hours without paying for idle clusters minimizing cost and operations.
Topics
Community Discussion
No community discussion yet for this question.