SAA-C03 · Question #791
A company receives data from several sources and stores the data in an Amazon S3 data lake. The company transforms the data and ingests it into multiple downstream data stores, including databases…
The correct answer is B. Use AWS Glue to create ETL pipelines. Use AWS Step Functions to orchestrate the workflow. AWS Glue provides a managed ETL service that simplifies the extraction, transformation, and loading of data from S3 to downstream data stores. AWS Step Functions can orchestrate complex ETL workflows. Amazon QuickSight can then create dashboards and visualizations from the…
Question
A company receives data from several sources and stores the data in an Amazon S3 data lake. The company transforms the data and ingests it into multiple downstream data stores, including databases and data warehouses. A solutions architect wants to design an extract, transform, and load (ETL) pipeline to orchestrate a process to prepare and load the data for analytics activities. The processed data must also be available for stakeholders through dashboards and visualizations. Which solution will meet these requirements with the LEAST development effort?
Options
- AUse Amazon EMR and a custom Scala script to create ETL pipelines. Use an AWS Lambda
- BUse AWS Glue to create ETL pipelines. Use AWS Step Functions to orchestrate the workflow.
- CUse an AWS Lambda function to create ETL pipelines. Use AWS Step Functions to orchestrate
- DUse custom scripts that run on Amazon EC2 instances to create ETL pipelines. Use AWS Glue to
How the community answered
(35 responses)- A3% (1)
- B91% (32)
- C6% (2)
Explanation
AWS Glue provides a managed ETL service that simplifies the extraction, transformation, and loading of data from S3 to downstream data stores. AWS Step Functions can orchestrate complex ETL workflows. Amazon QuickSight can then create dashboards and visualizations from the processed data. This combination minimizes development effort by leveraging fully managed
Community Discussion
No community discussion yet for this question.