QuestionQ1

VerifiedData Operations and Support

A company uses an Amazon S3 bucket to integrate multiple data sources into a centralized data lake. The company must perform multiple transformations and data-cleaning processes on the data so that the data is accessible to business partners.

The company requires a solution that enables multiple business partners to run SQL queries on the centralized data lake during normal business hours.

Which solution meets these requirements MOST cost-effectively?

Explanation

AWS Glue Flex is appropriate for non-urgent batch transformations, such as processing the previous day’s data after business hours, and reduces ETL cost through flexible execution. Amazon Redshift Serverless automatically provides and scales query capacity, charging for the capacity used when queries run; this is more cost-effective than maintaining a provisioned Redshift cluster for a workload limited to business hours.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!