nerdexam
AmazonAmazon

DEA-C01 · Question #282

DEA-C01 Question #282: Real Exam Question with Answer & Explanation

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.

Data Ingestion and Transformation

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

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

#AWS Glue Flex Job#Amazon Athena#Data Lake ETL#Cost Optimization

Community Discussion

No community discussion yet for this question.

Full DEA-C01 PracticeBrowse All DEA-C01 Questions