AUse 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.
BUse 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.
CUse 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.
DUse 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.
Answer 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:** [Configuring job properties for Spark jobs in AWS Glue](https://docs.aws.amazon.com/glue/latest/dg/add-job.html) · [Billing for on-demand compute capacity - Amazon Redshift](https://docs.aws.amazon.com/redshift/latest/mgmt/serverless-billing-on-demand.html)