Question

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?

Accepted Answer

B. Use an AWS Glue Flex Job after normal business hours to process the previous day's data, apply all necessary transformations. and load the prepared data into Amazon Redshift Serverless.

Answer

Use a provisioned Amazon EMR cluster after normal business hours to process the previous day's data, apply all necessary transformations, and load the prepared data into Amazon Redshift Serverless.

Answer

Use an AWS Lambda function after normal business hours to process the previous day's data, apply all necessary transformations, and load the prepared data into an Amazon Redshift provisioned cluster.

Answer

Use an AWS Glue Flex job after normal business hours to process the previous day's data, apply all necessary transformations, and load the prepared data into an Amazon Redshift provisioned cluster.